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

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!!!