However, due to the default responsive nature of Donut chart, we need to choose different inner radius value.Īs I decided to not show any labels of the rings for visual appeal, I added labels next to visual using bullet point kind of effect using the same colours I used on the visual. Now we can use the default Donut chart too. Also, when I first designed this report, default Power BI donut chart didn’t have an option to resize the ring, so I went for Circular gauge by MAQ software. Those days there were no grouping, but now we can group them as one visual too. Then I resized each visual in a way so that they look like one visual. So in this particular visual, I wanted to make it visually appealing, so I decided to show two metrics on each donut visual, the measure I want and the total number of schools. I also wanted to carry my story between report pages with colours. In my report, my story was to show the comparison of Ofsted school ratings among the total number of schools. The tricky bit of any good data visualisation is finding interesting data, inspiration and story. Be aware I created this report quite a long time ago, If I do it now, I probably would have taken a different approach or different visuals. Sorry to spoil, but it is nothing but a layered Donut Chart, but how I approached to show values probably is a good one.

As I promised to many, let’s see how I did it. This is a long overdue post, probably one of the most received questions on my blog was, How I designed a visual in one of my Power BI reports I published under my portfolio.

Sunburst chart tableau on mac