Multiple Donut charts in Power BI

[viswaaa]

Hello All,

I'm trying to create multiple donut charts by company but it doesn't look like this is possible in PBI. 

Could any one please help on this.

Here the original dimension is year in my data.

[v-kpoloju-msft · Accepted solution]

Hi @viswaaa,

Thank you for reaching out to the Microsoft fabric community forum. Additionally, thank you to @burakkaragoz, @suparnababu8, for his input regarding this issue. I have identified several alternative workarounds that may assist in resolving the thread.

In Power BI, you can create multiple donut charts by using different filters or slicers to represent data for each company. While Power BI does not inherently allow for multiple donut charts to be displayed in a single visual, you can create separate donut charts for each company on the same report page. 

Use “Small Multiples” (if donut chart supports it): As of now, default Donut Chart in Power BI does not support Small Multiples, but you can use Pie chart (built-in) or custom visuals that do.

Workaround: Use the Pie chart visual → under “Small multiples”, drag the “Company” field. Each company will get its own pie chart (which is functionally similar to a donut if inner radius is low).
Create small multiples (trellis) in Power BI

Create Multiple Donut Charts Manually: If you must use donuts, you can create separate donut visuals, each filtered by a specific company:

• Add a Donut Chart.
• Filter it using the Filters pane to show only Company A.
• Duplicate the visual and change the filter to Company B, and so on.
• Arrange them in a grid layout.

Outcome for Manually created Donut chart:

I am also including .pbix file for your better understanding, please have a look into it:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

[v-kpoloju-msft]

Hi @viswaaa,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-kpoloju-msft]

Hi @viswaaa,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-kpoloju-msft]

Hi @viswaaa,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[suparnababu8]

Hi @burakkaragoz 

You can use like this

You are saying that dimension is year, you may use line chart also.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

[burakkaragoz]

Hi @suparnababu8 ,

Thank you for your suggestion and for sharing the visual example!
Using a bar or line chart definitely makes sense when analyzing data by year. I appreciate your input and the clear explanation.

Thanks for your support to the community!

Best regards,
Burak

[burakkaragoz]

Hi @viswaaa ,

Yeah, Power BI doesn’t support small multiples for donut charts out of the box like it does for bar or line charts. But there are a couple of ways you can work around it:

Option 1: Use a separate visual for each category
You can create individual donut charts and apply a visual-level filter for each one (e.g. filter one for Furniture, one for Office Supplies, etc.). It’s manual, but works fine if you have just a few categories.

Option 2: Use a custom visual
There are some visuals in AppSource like “Multiple Donut Chart” or “Pie Chart Grid” that might help. They allow you to show multiple donut/pie charts based on a dimension like company or category.

Option 3: Use a matrix with measures
If you’re open to a different layout, you can use a matrix visual with conditional formatting or KPI indicators to show actual vs target in a compact way.

Let me know which direction you’re leaning and I can help you set it up.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI