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 was able to get it pretty close without a custom visual:

 

 

It's just a donut with additional measure for the whitespace and some shapes that are grouped togther. You can resize it if you click once and hold shift (to keep it square).  

 

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

  • tshumba's avatar
    tshumba
    Frequent Visitor
    4 years ago

    Absolutely fantastic !!! Thanks DataZoe 

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

    Thanks!!! Very nice. Is it also posible to color the circle conditional on a target value. Above target green and below target orange. I managed that with another visual (meter) But there the colors can be set conditional on a masure. See images.

     

    • 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