Forum Discussion

PwrBI01's avatar
PwrBI01
Post Patron
5 years ago
Solved

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.
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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

     

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

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

 

  • PwrBI01's avatar
    PwrBI01
    Post Patron
    5 years ago

    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.

    Imagen2.png

    Thanks in advance and sorry for the inconvenience.

    Regards.