Forum Discussion

AnnaZ's avatar
AnnaZ
New Member
9 years ago

Dynamically format a measure as $ or %

Hi there,   Is there a way we can dynamically format how a measure X is displayed, either in $0.00 or %, depending on the values in another field? I have a separate field called 'Data Type' which I...
deldersveld's avatar
deldersveld
Icon for Resident Rockstar rankResident Rockstar
9 years ago

Try creating the measure with either an IF or SWITCH statement based on the value of the other field. You could then use the FORMAT() function to dynamically change the display format.

 

Something like = SWITCH('table'[other field],"Value A",FORMAT([measure],"Currency"),"Value B",FORMAT([measure],"Percent"))


Here's more detail on the different options you can supply for the FORMAT() function: https://msdn.microsoft.com/en-us/library/ee634924.aspx. Scroll down and see the options for Number and use either the pre-defined or custom numeric formatting options.

AnnaZ's avatar
AnnaZ
New Member
9 years ago

deldersveld

 

I used the switch function as below but the new measure is now formatted as a text and cannot be added to the visual.

 

CurrentValueFormatted = switch([DataTypeMeasure],"P",format([CurrentPercentValue],"Percentage"),"A",format(HotelKPICalculation[CurrentPercentValue],"Currency"))