Forum Discussion

jaspijk's avatar
jaspijk
Icon for Helper I rankHelper I
6 years ago
Solved

circle gauge / donut

  Hi,   I'm looking for a visual like in the picture. I also want to color te circle, conditional on het value. Is this posible?
Need Help
Show and Tell
Tips and Tricks
  • DataZoe's avatar
    DataZoe
    6 years ago

    jaspijk You're welcome! If it's solved you can mark it as the solution too 🙂

DataZoe's avatar
DataZoe
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

I did try to get the donut to do conditional formatting, but I wasn't able to get it to do it. You can do conditional formatting on a column chart though. I like the circle graphic too but if you really need that color change, you may consider a similar set up with column or bar (sideways instead) chart:

 

 

I've update the PBIX too: https://github.com/DataZoe/PBIX/blob/master/DonutShape.pbix 

DataZoe's avatar
DataZoe
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

jaspijk I saw another post from v-zhenbw-msft where they did conditional formatting on a line chart, and that would also work for your donut!

 

You create a measure for each of the colors you want:

 

 

Measure Green = if([Measure]>80,[Measure],blank())

Measure Yellow = if([Measure]>50&&[Measure]<=80,[Measure],blank())

Measure Red = if([Measure]<=50, [Measure],blank())

 

 

then put them all in the donut values. Change the colors for each to the right color:

Updated PBIX: https://github.com/DataZoe/PBIX/blob/master/DonutShape.pbix 

  • jaspijk's avatar
    jaspijk
    Icon for Helper I rankHelper I
    6 years ago

    Wow. Thank You very much. This is great!!!

  • jaspijk's avatar
    jaspijk
    Icon for Helper I rankHelper I
    6 years ago

    'm so thankfull! Can I ask one last question. I've to make the visual 36 times on 36 measerments. Di I've tot make all the measerments 36 times or is there a way to simplify that, to change only the measerment on witch the score is based. Thanks.

    • DataZoe's avatar
      DataZoe
      Icon for Microsoft Employee rankMicrosoft Employee
      6 years ago

      jaspijk Yes, you can have [Measure] be based on multiple measures this way:

       

      1. Create a table (Enter Data) with all your base measure names:

      2. Modify your [Measure] to switch between what is selected:

       

      Measure = 
if(HASONEFILTER('Base Measures'[Selected Measure]),
    switch(SELECTEDVALUE('Base Measures'[Selected Measure]),
        "Base Measure 1",[Base Measure 1],
        "Base Measure 2",[Base Measure 2],
        "Base Measure 3",[Base Measure 3],
        "Base Measure 4",[Base Measure 4],
        "Base Measure 5",[Base Measure 5],
        blank())
    ,blank()
)

       

      3. Now you have 2 options, you can put a visual level filter that picks which measure is on the card/donut for each visual:

      4. Or you could control one with a slicer:

       

      I've updated the PBIX too: https://github.com/DataZoe/PBIX/blob/master/DonutShape.pbix 

      • jaspijk's avatar
        jaspijk
        Icon for Helper I rankHelper I
        6 years ago

        Hi. Ik don't know how to thank You!!! Thanks!!!!!!