Forum Discussion
Solved
Change data format based on metric selection
Hi, I have a report where i select different metrics based on a button selection(bookmarks). My stacked column chart displays in thousands based on selection however how can i change data format ...
Hi dokat
With a bookmark, you can display a different visualization each time, so you can design and format each one according to your preferences.
It would be helpful if you could attach a sample file if I didn't understand correctly.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Ritaf1983 Thanks for your response but that didnt work. I tried below measure it didnt give any error message however returned blank values, When 'ID'[ID]= 1,2,3,4, I'd like values in stacked column chart to display in $0.00 K" format. If 'ID'[ID]=9 in % format "0.0%". Below you will find the screen shot of the results. Not sure what the work around is.
Output Selected Calculation =
SWITCH(
SELECTEDVALUE('ID'[ID])
,1,FORMAT(CALCULATE([Output Gross Sales]),"$#,##0")
,2,FORMAT(CALCULATE([Output OIS]),"$#,##0")
,3,FORMAT(CALCULATE([Output NS]),"$#,##0")
,4,FORMAT(CALCULATE([Output Trade Spend]),"$#,##0")
,5,CALCULATE([Output Volume])
,6,CALCULATE([Output Packages])
,7,CALCULATE([Output ASP])
,8,CALCULATE([Output ANSP])
,9,FORMAT(CALCULATE([Output Trade Rate]),"0.0%")
)