Small multiples In Pie chart

[viswaaa]

Hi All,

How to show small multiples pie charts in Power BI.

Below is my data shows % sales for each country per year.and I need to show pie charts for each percentage.

So I need to show 9 pie charts which show sales  % 

[Shahid12523]

Power BI doesn’t support small multiples for pie charts natively. To show 9 pie charts (3 countries × 3 years), you have three options:
- Manual Method: Create 9 separate pie charts and filter each by country and year.
- Deneb Visual: Use Deneb (Vega-Lite) to build dynamic small multiples of pie charts.
- Matrix + SVG: Generate pie charts as SVGs via DAX or R and embed them in a matrix.

[FarhanJeelani]

@grazitti_sapna , Your answer is completely wrong. Have you ever tried Pie/donut chart?

[Natalie_iTalent]

Hello @FarhanJeelani,

The response in which you were referring to has been removed for being inaccurate.  Let me know if you have any questions.

Best,

Natalie H.

Community Manager 

[FarhanJeelani · Accepted solution]

Hi @viswaaa ,

Power BI does not support small multiples for pie/donut charts out of the box. You won’t get a grid of 9 pies using the built-in pie visuals.
A practical workaround to get a “grid of charts by year” effect

Use a 100% stacked column (or bar) chart and enable Small multiples by Year. This gives you a mini-chart per year, each showing the share by country, which visually replicates the idea of small multiples pies.
What you’ll need to do

Model cleanup and calculation
If your goal is shares that sum to 100% per year, you should compute per-country shares within each year.
Create a measure for the year total (sales or the relevant metric per year): YearTotal = CALCULATE(SUM(YourTable[Amount]), ALLEXCEPT(YourTable, YourTable[Year]))

Create a measure for each country’s share of the year: CountryShare = DIVIDE(SUM(YourTable[Amount]), [YearTotal])
Note: If your data already contains percentages that do not sum to 100 per year (e.g., 90%, 70%, 50% for a year sums to 210%), you’ll need to normalize them to sum to 100% per year or use them in a way that reflects what they truly measure. The “share” approach assumes a per-year total to split.

Build the visual
Visual: 100% stacked column chart
Axis: Country
Values: CountryShare
Small multiples: Year
Formatting: Turn on Data labels, format as a percentage (0–100), set appropriate decimal places.

Please mark this post as solution if it helps you. Appreciate Kudos.

[viswaaa]

Hi ,

I dont see small multiples option in my pie chart