How to create multiple layers of donut/sunburst chart by year

[Anonymous]

Hi I would like some help creating the below visual in Power BI. I have year and value data in a table. I have tried sunburst chart but unable to get individual rings for year selected.

Example of data

Year % Total
2021 78%
2020 26%
2019 46%
2018 99%
2017 100%
2016 36%
2015 47%
2014 75%
2013 84%
2012 93%
2011 66%
2010 29%
2009 85%

[selimovd]

Hey @Anonymous ,

you have a few possibilities to do that.

Give the Sunburst visual a try:

Sunburst (microsoft.com)

Otherwise you could use charticulator to create that:

Home | Charticulator

Or the advanced donut visual:

Advanced Donut Visual (Light Edition) (microsoft.com)

Or the advanced pie and donut:

Advanced Pie and Donut - xViz (microsoft.com)

Or check the  following approach:

How I designed a layered donut chart - Prathy's Blog...

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic