Forum Discussion
harshadrokade
3 years agoPost Partisan
Formatting values separately in unpivot value column
Hi All, I have below data- Category Location Parameter1 Parameter2 Parameter3 Parameter4 Parameter5 Parameter6 C1 L1 25 5% 54 2% 24 19% C2 L2 48 8% 33 3% 99 8% C...
- 3 years ago
Hi harshadrokade ,
If you are using the latest version of Power BI you can use the Dynamic Format, create a measure and on the format select Dynamic then add the following code:
SWITCH ( TRUE (), SELECTEDVALUE ( 'Table'[Attribute] ) IN { "Parameter2", "Parameter4", "Parameter6" }, "#.0%", "#" )https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dynamic-format-strings
harshadrokade
3 years agoPost Partisan
MFelix amitchandak v-xiaotang Ashish_Mathur Greg_Deckler Anonymous bill_lalonde Wastidium
Can u pls help here