RAG color for Gauge Chart

[chayanupadhyay]

Hello Everyone, 

If anyone has solve the below problem or implemented below case then please let me know:

Problem Statement:

Need R - Red, A- Amber and G- Green color in Gauge visualisation, color coding will be dependent on the values,

for ex: if target is less or equal to 30% then R, if greater than 30 and less or equal to 60% then A, if greater than 60% then green.

I have looked other answers and most suggested solution to use Custom Visual but i can't use custom visual

Data Source: Azure Analysis Service with Live Connection.

Please let me know if someone has achieved like this with Gauge visualisation, if not then what is the alternate or proposed solution to achieve (can go with other visualisation but AAS as data source with Live connection).

I hope the explaination is good enough to understand the problem statement, in case of any question with the problem statement please let me know.

Thank you for reading and your support 🙂 🙂

[v-shex-msft]

Hi @chayanupadhyay,

>>if target is less or equal to 30% then R, if greater than 30 and less or equal to 60% then A, if greater than 60% then green.

Nope, current gauge chart not support these features.

For your requirement, I'd like to suggest you to conditional format feature to achieve your requirement:

Conditional Formatting in Power BI

Conditional Formatting for a matrix and table Power BI

Notice: current condition formula feature only works for specific visuals.

Regards,

Xiaoxin Sheng

[chayanupadhyay]

Thank you @v-shex-msft for your response.

I am aware of the conditional fomatting available in Table and Matrix visualisation but just wondering if we can achieve this by doing any customizing at Power BI level or cube end (AAS tabular model).

One more question, can we achieve same thing in 100 % Stacked column chart? if yes then please guide me on this.

Thank you again !!!

P.S.: Please vote for this idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32980939-conditional-formatting-i...

[v-shex-msft]

HI @chayanupadhyay,

>>One more question, can we achieve same thing in 100 % Stacked column chart? if yes then please guide me on this.

Based on test, 100% stacked column chart not support this.

Regards,

Xiaoxin Sheng