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...
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"))

 

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

AnnaZ

 

It's true. Once you use Format() function, the data type will be converted to text, it will throw error if you change it to numeric type.

 

It's not possible to give a dynamic format on a measure but still keep numeric data type.

 

Regards,