Traffic light KPI with an threshold input

Hi Anonymous ,

Believe that this can be solved using a measure in PBI no need for the additional columns and this can be done in a dinamic way something similar to:

Condittional formatting =
SWITCH (
    TRUE ();
    SUM ( Table[column] ) < 1000; "Red";
    SUM ( Table[column] ) >= 1000
        && SUM ( Table[column] ) >= 2000; "Yellow";
    SUM ( Table[column] ) < 2000; "Green"
)

You can have the values to be dinamic based on a table of thresholds but using this type of measure is sufficient, what I believe is a best practice is to create one for each column you want to have condittional formating, otherwise you will also need to had a disconnect table to pick up the columns.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.