Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jaspijk
Helper I
Helper I

circle gauge / donut

Schermafbeelding 2020-04-25 om 10.22.58.png

 

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?

1 ACCEPTED SOLUTION
DataZoe
Microsoft Employee
Microsoft Employee

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

Respectfully,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

View solution in original post

14 REPLIES 14
MAQSupport
Solution Supplier
Solution Supplier

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

I was able to get it pretty close without a custom visual:

 

DonutShpe.JPG

 

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 

Respectfully,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

Absolutely fantastic !!! Thanks @DataZoe 

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.

 

Schermafbeelding 2020-04-28 om 17.57.06.pngSchermafbeelding 2020-04-28 om 17.59.43.png

DataZoe
Microsoft Employee
Microsoft Employee

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:

 

DonutOrBar.JPG

 

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

Respectfully,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

DataZoe
Microsoft Employee
Microsoft Employee

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

donutColors.JPGDonutGreen.JPGdonutRed.JPG

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

Respectfully,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

'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
Microsoft Employee
Microsoft Employee

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

SelectedMeasureTable.JPG

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:

VisualMeasureSelect.JPG

4. Or you could control one with a slicer:

MeasureSelectWithSlicer.gif

 

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

Respectfully,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

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

DataZoe
Microsoft Employee
Microsoft Employee

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

Respectfully,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

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

amitchandak
Super User
Super User

Hi

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 

 

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors