We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
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?
@Daniel29195 when I convert to text it changes it back to a decimal 😞 same thing happens when I remove the change type all together.
Hi @Daniel29195
Have you tried using dynamic format strings?
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dynamic-format-strings
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 🫡👍
User | Count |
---|---|
67 | |
61 | |
47 | |
35 | |
32 |
User | Count |
---|---|
87 | |
72 | |
57 | |
51 | |
45 |