cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Sunburst with two circles representing actual progress vs planned progress

I have multiple sharts/reports that I whant do present on a dashboard but I can't figure out how to solve this problem I have with the sunburstdiagrams. 

 

In my reports I tweeked this by adding two diffrent sunbursts and laying them above each other. And I can't do that on a dashboard. 

This is what it looks like 
2019-04-27_21-36-06.pngHow do I make the inner circle based on the "... - Bas" values and the outer circle based on "... - Aktuell"?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Sage
Solution Sage

Re: Sunburst with two circles representing actual progress vs planned progress

Hey @TommyMossberg 

 

You can use SVG for that.

Please look at this video, there are more/others, just search for it.

 

For example:
I have a table with 2 columns, radius 1 and radius 2.

I have added 2 custom columns with the svg/html code.

The only property that is dynamically changed, in this example, is the radius, but any property can be controled and chnaged the same.

Circle1 = "<svg xmlns='http://www/w3/org/200/svg' viewBox='0 0 20 20'>
<circle  fill=' blue '  r='"& Table1[R2] &"' cx='5' cy='5'>
</svg>"

Circle2 = "
<svg xmlns='http://www/w3/org/200/svg' viewBox='0 0 20 20'>
<circle  fill=' green '  r='"& Table1[R1] &"' cx='5' cy='5'>
</svg>"

Add a HTML viewer and show the columns, should show you circles.

Place the HTML containers on top of each other, so circles will show one on top the other.

This is how it looks (Circle1 on top of Circle2) -->
2019-05-20 11_00_41-papercut - Remote Desktop Connection.png

 

You can add more HTML tags like opacity, stroke, sizes, colors and more.

Examples of SVG properties - https://www.w3schools.com/html/html5_svg.asp

 

Good luck!
A

 

View solution in original post

4 REPLIES 4
Highlighted
Solution Sage
Solution Sage

Re: Sunburst with two circles representing actual progress vs planned progress

Hi @TommyMossberg 
Have you watched this? 

https://www.youtube.com/watch?v=ADCvMkVV_fg

 

Cheers!

Highlighted
Frequent Visitor

Re: Sunburst with two circles representing actual progress vs planned progress

Hi @AClerk 
I've tried with that sunburst visualization but with no luck.


The problem, as I see it, is that the outer circle is still based on the values in the inner circle.
What I want is two circles where the inner circle is based on som columns and the outer circel is based on other columns whitout any dataconecctions between the circles.

They are only for visualization to show actual progress (outer) and planned progress (inner).
 

Highlighted
Solution Sage
Solution Sage

Re: Sunburst with two circles representing actual progress vs planned progress

Hey @TommyMossberg 

 

You can use SVG for that.

Please look at this video, there are more/others, just search for it.

 

For example:
I have a table with 2 columns, radius 1 and radius 2.

I have added 2 custom columns with the svg/html code.

The only property that is dynamically changed, in this example, is the radius, but any property can be controled and chnaged the same.

Circle1 = "<svg xmlns='http://www/w3/org/200/svg' viewBox='0 0 20 20'>
<circle  fill=' blue '  r='"& Table1[R2] &"' cx='5' cy='5'>
</svg>"

Circle2 = "
<svg xmlns='http://www/w3/org/200/svg' viewBox='0 0 20 20'>
<circle  fill=' green '  r='"& Table1[R1] &"' cx='5' cy='5'>
</svg>"

Add a HTML viewer and show the columns, should show you circles.

Place the HTML containers on top of each other, so circles will show one on top the other.

This is how it looks (Circle1 on top of Circle2) -->
2019-05-20 11_00_41-papercut - Remote Desktop Connection.png

 

You can add more HTML tags like opacity, stroke, sizes, colors and more.

Examples of SVG properties - https://www.w3schools.com/html/html5_svg.asp

 

Good luck!
A

 

View solution in original post

Highlighted
Frequent Visitor

Re: Sunburst with two circles representing actual progress vs planned progress

@AClerk Thank you!

 

svg will solve this specific problem for me and give me completely different toolbox to tweak the presentation of different data.

 

This will be fun! 

 

 

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors