Forum Discussion
Create a multiple ring chart
Hi guys,
I am trying to create the following ring chart in Power BI,
How can I create it?
Thanks in advance.
Regards.
Tried it out in Charticulator. How does this look? I wasn't able to export the visual at the moment, or would have attached a link to it.
Regards,
Pat
21 Replies
Tried it out in Charticulator. How does this look? I wasn't able to export the visual at the moment, or would have attached a link to it.
Regards,
Pat
Hi mahoneypat,
It seems great for me, if there is possible I would appreciate if you can send me the visual. If not, I will try to create it when I have time.
Thank you very much.
Regards.
I rebuilt it to get around the error, but for some reason this particular visual is throwing an error when I try to export. I will let you know if I can build it a little differently and get it to export.
Regards,
Pat
Hi again mahoneypat,
I am trying to create the chart with Charticulator but I don't know how to put the measures 'YTD Sales' and 'Other sales' together, can you help me please?
Thanks in advance,
Regards.
Here is a link to the chart file. Hopefully it helps. I haven't seen a response on the GitHub issue I posted yet.
https://drive.google.com/file/d/14zhNLZ7EKZmP2svnfndiMT8s1T_MT5wJ/view?usp=sharing
Regards,
Pat
There @mahoneypat,
I am having problems to open the document because it says the format is not .chart
If I open to .chart I can open the table but I can visualize the chart.
Regards.
PwrBI01 FYI that I found a work around for the error on Charticulator. By adding a constant category on the other axis, I was able to export polar scaffold charts again. Since there is just a single value on that axis (and the label is hidden), the chart looks the same. I made the chart both ways (with the two measures pivoted and unpivoted) and export the pbiviz, chart file, and template file. All 6 files are in this folder.
https://drive.google.com/drive/folders/1HlThCwUeR-Lkp2H7qmoBoSuMM7yFOQrq?usp=sharing
Regards,
Pat
I tried it, and it initially looked the same. For the Index, Year, and Value fields, pull down the arrow and choose Don't Summarize to get it looking right. Also, the second/upper bar is there but can't be seen as it has same color as background and white text (if i change background color, i see the text but not the bar). You'll need to fix that too.
Regards,
Pat
Hi mahoneypat,
Thank you very much for everything, now my chart looks good.
Now I just need to create a measure Switch to try to work with real values calculated from another data tables.
Regards.
PwrBI01 , see if Sunburst can fit in your need
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380767?tab=overview
or Advanced Donut Visual
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380858?tab=overview
or Advanced Pie and Donut - xViz
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200001917?tab=overview
PwrBI01 , also these two ?
or Advanced Donut Visual
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380858?tab=overview
or Advanced Pie and Donut - xViz
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200001917?tab=overview
If you can't find an existing visual, this should be possible with Charticulator.
Can You Say "Charticulator"? - I Knew You Could - Portland Power BI UG - YouTube
Regards,
Pat
Hi mahoneypat,
First of all, thank you for your answer.
Do you know if there a way to create it not having categories?, I would insert measures with the final result if possible. I send you the chart I want to create (I forgot to insert the legend in the previous one).
I am looking for an existing chart, but if there is no possible I will try to create it with the tool you have sent me if there is possible.
Regards.
It should work but you will need a category column. You have to add a table that has YTD and Total values in a column and then maybe a IF/SWITCH measure to return the right calculation. I may take a shot at a charticulator visual later. Will update if so.
Regards,
Pat
It is harder to build it starting with data structured like that, but doable. Requires adding two marks to the glyph and connecting them. I built it that way too, but got the same error when I tried to export the pbiviz. I put an issue report in on GitHub for Charticulator but don't know how soon will get a response and if there is a workaround.
FYI that it is easier to building having a table of 4 rows, 3 columns (Year, Measure (YTD or Total), and Value). Then you just use Measure for the Fill color field.
Regards,
Pat
FYI that PowerBI.tips also hosted a version of Charticulator but it is an older version. This one didn't have the error I was seeing. It doesn't have as many format options available in Power BI when you use it, but it works. I attached the pbiviz. FYI that I built it with data in this format. Note too that with visuals from Charticulat you need to add an index column to your data so each row has a unique value to be used in the Granularity field.
Category
Measure
Value
A
YTD
200
A
Total
300
B
YTD
150
B
Total
175
Here is the link to the pbiviz file. https://drive.google.com/file/d/1oO14R7ye1Th5gotMqiiFUtQU0yFDNyD_/view?usp=sharing
Regards,
Pat
There @mahoneypat,
Thank you very much for the visual.
I need to do small changes on it, could you please send me it to open it with charticulator?
I have problems when the sales of 2019 are higher than 2018 (because I want 2018 to have 90º). I have solved this making the chart with 180º and introducing a third measure (called blank) that I will put with no colour when I use it, but I don't know how to make the size of the categories depending on their values and another small changes.
Thanks in advance and sorry for the inconvenience.
Regards.
