Forum Discussion
harshadrokade
Post Partisan
Post PartisanFormatting 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...
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
MFelix
Super User
Super UserHi harshadrokade,
After the unpivoting see if the step for the changed type is added if yes delete that step and add the custom column then redo the formatting.
harshadrokadePost Partisan
Post PartisanThanks a ton MFelix . Your help was very useful..