Hi there.
Workbook attached. v2021.2.8
On my Sheet 3, I'm using a simple parameter to show [profit] or [profit ratio]. I have the percent as percentages as labels. When I select the [profit], the numbers still show as a percentage. Is there a way to get the number format to change automatically depending on what is selected in the parameter?
Thanks
Hi LaShawnta,
Unfortunately, there is no built-in functionality to do this at this point.
I usually create two fields (one for each label that I want to show with a specific format), in this case, the following:
[Profit Label]
if [prmSort]="Profit" then sum([Profit])
else NULL
END
[Profit Ratio Label]
if [prmSort] = "Profit Ratio" then [Profit Ratio]
else NULL
END
Then, place both labels on the label mark (and on the tooltip if you want) right next to each other, done!
The result looks like this:
If you also want the axis to switch the unit between % and $ I would recommend building two separate sheets instead and showing/hiding them based on your parameter selection.
Hope this helps :)
