Conditional fromatting based on the value of a measure

[BalazsNy]

Dear All,

Could you please help me how to format a field based on the value of a measure?

I have a simple KPI table, which has Passed% & KPI target % columns (both of them are measures!).

I would like to highlight with red font color those passed% values which are below the expected KPI target% (in this example Medium & Complex)

Thanks for your help in advance!

[mattiasdesmet]

Hi,

you can achieve this by using the Cell elements option:

- on the visual (e.g. table) expand cell elements,

- fore color : ON and click on Fx

- in the wizard you define "Rules" as per below screen and it allosw you to configure the formatting

The result in the table is then formatted:

[BalazsNy]

Hi,

To tell you the truth, it is not 100% clear for me, how the 2 fields are compared with each other in this way. It takes into account only the value of Sum of PedalCycles & colored if it is under 30K...

[mattiasdesmet]

Hi, this was an example to point you to where you can setup the conditional formatting for your measure. My example is based on measures I had