Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Multiple Guage Colors Base On Status

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.

 

Need Help

4 Replies

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HiAnonymous， 

     

    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.

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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"
    )