Gauge chart based on slicer

[Anonymous]

Hello,

I would like to display all the sales revenue in the gauge chart and then select a store to display how much this store revenue represent in total.

Aditionnaly, the gauge should be red if it haven't meet the quota and green if it does.

I created this measure to do it but i can't understand why it dosen't work : 

Conditionnal =

IF(Ventes[CA HT]>Objectifs[Objectif],"Green","Red")

Here's the Pbix file. It's the second sheet named "Magasins" 

The gauge should display 2,32M for 2020 but it displayed 4,65 and i don't understand

https://we.tl/t-Ru8YrMnQUU

Thanks for reading

[v-jianboli-msft · Accepted solution]

Hi @Anonymous ,

Conditionnal =
IF(Ventes[CA HT]>Objectifs[Objectif],"Green","Red")

This is a calculated column:

If you want the color of Gauge chart changed based on slicer, you may need a measure like this:

Color = IF(Ventes[CA HT]>SUM(Objectifs[Objectif]),"Green","Red")

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-jianboli-msft · Accepted solution]

Hi @Anonymous ,

If you want the maximum be 2.32, you may need to set it. Like this:

Measure 2 = CALCULATE([CA HT],ALLEXCEPT(Dates,Dates[Year]))

For more details, please, refer to:

Radial gauge charts in Power BI - Power BI | Microsoft Learn

Besides, this question is beyond the original topic of the thread, so if you have other questions, please consider marking the replies that have helped you and creating a new thread for the new question in order to better help others with similar questions, which will also enable more people to help you.

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-jianboli-msft · Accepted solution]

Hi @Anonymous ,

Conditionnal =
IF(Ventes[CA HT]>Objectifs[Objectif],"Green","Red")

This is a calculated column:

If you want the color of Gauge chart changed based on slicer, you may need a measure like this:

Color = IF(Ventes[CA HT]>SUM(Objectifs[Objectif]),"Green","Red")

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.