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.
Hi Everybody,
I have a matrix in which one of the columns should be displayed as %.
The column is a measure.
How do i change this to a % and also make sure its a whole numbe like 5% or 4% without a decimal point?
I have noticed i have the option of "Field Formating" under Format in the report window when marking the matrix but for some reason it is grayed out.
Thanks.
Solved! Go to Solution.
Is this import mode or DirectQuery?
Generally you click the % formatting option and then reduce the decimal places to 0.
You might try using the FORMAT function.
Is this import mode or DirectQuery?
Generally you click the % formatting option and then reduce the decimal places to 0.
You might try using the FORMAT function.
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 |
---|---|
115 | |
100 | |
90 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |