Forum Discussion
Solved
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...
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
Hi 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.
Thanks a ton MFelix . Your help was very useful..