circle gauge / donut

[jaspijk]

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?

[MAQSupport]

Hello @jaspijk ,

Please check Circular Gauge by MAQ Software  and Ring Chart by MAQ Software

Let us know if it meet your requirements.

For any further queries or enhancement requests, please contact us at support@maqsoftware.com 

Thanks

[DataZoe]

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]

Absolutely fantastic !!! Thanks @DataZoe 

[jaspijk]

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]

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]

@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]

'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]

@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]

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

[DataZoe · Accepted solution]

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

[jaspijk]

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

[amitchandak]

@jaspijk , See if this can help https://www.youtube.com/watch?v=jQ0Q6hlq1_8

[jaspijk]

Hi,

Thanks for your mesaage. I know that one. But I mean exactely the image I've showed. Only one color at the time (red, orange or green) 

[v-xuding-msft]

Hi @jaspijk ,

I serched a few similar visuals. Hope they work for you.😉

Circular Gauge by MAQ Software - Power BI Visual Introduction 

Power BI Custom Visuals- Circle KPI Gauge 

Advanced Gauge