Colorcoding for percentages higher/lower than 100/-100

[SamuelGregor]

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)

[jthomson]

Could you not conditionally format it using the raw percentage field which should still be a number?

[SamuelGregor]

i am not quite sure what you mean - could you please give me an example?

thx,

sg

[jthomson · Accepted 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

[SamuelGregor]

works like a charm! thanks!