Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
jcastr02
Post Prodigy
Post Prodigy

Unpivot column but then column formatting is removed

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?

Screenshot 2024-01-23 164903.pngScreenshot 2024-01-23 164920.png

4 REPLIES 4
jcastr02
Post Prodigy
Post Prodigy

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


Screenshot 2024-01-23 171740.png

Hi @Daniel29195 

 

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





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

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

Daniel29195
Super User
Super User

@jcastr02 

 

Daniel29195_0-1706047778829.png

 

solution : 

convert to text . 

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

Daniel29195_1-1706047800809.png

 

 

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 🫡👍

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.