The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
75 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |