Multiple Guage Colors Base On Status

[Anonymous]

So I am looking to create a guage that uses multiple colors based on a given status in the data.  For instance we have a goal and I want to display the teams progress.  So we have one value as "Achieved" and another value as "Reserved" to show our pipeline towards our goal.  So in the same guage, I want Achieved values to show up as one color and the Reserved values to show up as another. 

I can obviously do this rather easily with a donut chart, but it does not show us how we are progressing towards our goal.

[Anonymous]

@Anonymous & @MFelix ,

Unfortunatly neither of those options worked. What I am looking for is half of that guage would be blue for the "Achieved" value, then the other half would be red for my "Reserved" value as shown in this image.

 

I did create a measure as suggested and used the following which did not work:

Guage Progress =
SWITCH(
SELECTEDVALUE('Rebate Intake'[Phase]),
"Achieved","Green",
"Reserved","Yellow"
)

[MFelix]

Hi  @Anonymous ,

You cannot achieve this with the gauge visualization by default, you need to use a custom visual (https://xviz.com/visuals/advanced-gauge/) or using a colection of several visualizations and group them.

[Anonymous]

Hi@Anonymous， 

you can try to create a measure like this：

Gauge Color =
SWITCH ( TRUE (), [Reserved] > ValueA, "Green", [Achieved] > ValueB, "Red" )

Then you can use this DAX measure in the conditional formatting, this time, you need to select Format by Field Value, and then select the Gauge Color measure here.

For more information，you can refer to this article ：

https://radacad.com/sentiment-colors-for-gauge-visual-in-power-bi  

Hope it helps.

Best Regards,

Caitlyn Yan

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

[MFelix]

Hi @Anonymous ,

What do you mean by different colours on the same gauge you want to select the values (achieved / reserverd) from a slicer and the gauge change colours? you want to have both of them in the same gauge at the same time?

Can you share a sample of your data and expected result.

If you want to  usea slicere you can use a condittional formatting something similar to:

Colour = SWITCH(SELECTEDVALUE('Table (2)'[Satus]) , "Actual", "Green", "Reserverd", "Blue", "Grey")

See PBIX file attach, the condittional formatting can also be applied to the target line.