Unpivot column but then column formatting is removed

[jcastr02]

When I unpivot columsn the formatting (in example below the % is turned into a decimal place.  Do we know if there is a work around to keep the same formatting after unpivoting?

[jcastr02]

@Daniel29195  when I convert to text it changes it back to a decimal 😞 same thing happens when I remove the change type all together.

[danextian]

Hi @Daniel29195 

Have you tried using dynamic format strings?
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dynamic-format-strings

[Daniel29195]

can you please share the file so i can take a look at it ? @jcastr02 

[Daniel29195]

@jcastr02 

solution : 

convert to text . 

remove the auto added step :  changed type .  ( then the column should automatically change to abc as datatype ) 

let me know if you have any other concerns. 

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍