Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have created one measure for my bar chart (mentioned below) and applied number formatting as measure expression
dual('Personnel Attended Educational Sessions'& ' ' & ' - '&
num(sum({$<Year={2020}>} NumberOfAttendees ),'#,##0'), num(sum({$<Year={2020}>} NumberOfAttendees ),'#,##0'))
with this i have achieved my requirement see image below
But the problem is i am not able to change X-axis label format (ex: i don't want 1k instead of that 1,000). I can't change measure expression in number formatting because client needs full label name whatever he gave.
So how to achieve this Is there any alternate way or do i need to change any thing in my measure only.
Can guys please help me out from this by your suggestions
Note: we can't use custom visualization also
Thanks in advance
Regards,
BVSS
any thoughts @Michael_Tarallo @swuehl @sunny_talwar @tresesco
@Patric_Nordstrom - can you take a look?
The axis labels works with num but not with dual.
Thanks,
Patric
Same question here. Have a button driving which metric is displayed in the line chart. 1st measure is dollar formatted with 2 decimal places. 2nd measure is whole number with no decimal places. The value labels on the chart adjust but the y-axis stays dollars.
1st master item expression
num(sum([Order Amount]), '$#,##0.00', '.' , ',' )
2nd master item expression
num(count(distinct [Order Number]), '#,##0', '.' , ',' )