Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have some columns that were percentages, but when I unpivoted them they turned into decimals. Is there a way to turn them back into percentages without affecting the other values? Thanks!
we can only set one data type for one column, but we have some workarounds to display the data.
Measure = if(CONTAINSSTRING(max('Table (2)'[attribute]),"%"),sum('Table (2)'[result])*100&"%",sum('Table (2)'[result]))
Proud to be a Super User!
that sort of worked, but the percentages still have a long string of numbers after the decimal. it also only worked for the first set of percentages and not the rest
you can create a dim table or create a sort column in the existing table.
then sort by the sort column
Sort one column by another column in Power BI - Power BI | Microsoft Learn
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
82 | |
74 | |
66 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |