Small multiples In Pie chart

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.