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 everyone!
I am trying to get conditional formating for measure (in percentages) inside the "Matrix" object.
Usual conditional formatting is quite easy and straight forward to set up, however, i am missing one option which Excel had.
In case the number (in this case percentage) is higher/lower than 100/-100, i would like to have it as ">100%" with color coding.
Is this somehow possible?
example: (">100%" was achieved with IF function, however now it is stored as a string and therefore no color coding)
Solved! Go to Solution.
I assume you have a measure that is giving a percentage of something within your data model, let's call it [PercentageMeasure], which'd be a number, then you've got another measure, let's call it [PercentageButGroupingOver100], where you've used your IF statement to get it saying >100% as in your example. It's only a fairly recent addition so maybe update your desktop version, but you can now format [PercentageButGroupingOver100] by [PercentageMeasure], playing about with rule-based conditions should get you the result you want
Could you not conditionally format it using the raw percentage field which should still be a number?
i am not quite sure what you mean - could you please give me an example?
thx,
sg
I assume you have a measure that is giving a percentage of something within your data model, let's call it [PercentageMeasure], which'd be a number, then you've got another measure, let's call it [PercentageButGroupingOver100], where you've used your IF statement to get it saying >100% as in your example. It's only a fairly recent addition so maybe update your desktop version, but you can now format [PercentageButGroupingOver100] by [PercentageMeasure], playing about with rule-based conditions should get you the result you want
works like a charm! thanks!
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 |
---|---|
110 | |
98 | |
79 | |
64 | |
56 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |