Simple RAG Health Indicator

[pbi138]

Hi All,

I am making a dashboard for a manufacturing facility and I need to displays few simple health indicators. These are between 0 and 100 and should display in red when the value is between 0 and 33, amber between 33 and 66 and green if between 66 and 100.

The goal is to make these bad values 0-33 pop out. I've tried a bullet chart but that doesn't really make these bad values stand out. I've tried the custom KPI visual but I am struggling to get the colour coding needed. 

Is there a way to create a simple health indicator like this in Power BI? Its seems quite difficult to achieve what I need without conditional colours.

Thanks for your help!

Tom

[v-sihou-msft]

@pbi138

For this kind of "indicator", you can try conditional formatting on table visual. You can assign threshold value for each bucket. For more details, please refer to: Conditional formatting in tables

Regards,

[pbi138 · Accepted solution]

Thanks for your reply @v-sihou-msft. I actually ended up using 'Card with states by OKViz'. This works fine except you cannot create alerts like for normal cards. 

Cheers,

Tom