Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi all,
Can we create small multiples in pie charts in powerbi.
Like i have a field name "deviceID". I want to create pie charts showing rejection causes for each of the devices. So for each unique device there should be a pie chart is it possible in PowerBI?
Thanks
Hi ALL,
Firstly , thank you for yours solution!
And @YumeenShahid ,it seems there are multiple great solutions provided. If one of these has resolved your issue, you could consider marking it as the solution to help others who might face a similar problem.
Feel free to reach out if you have any further questions!
Small multiples are not directly available for pie charts in Power BI. You can dynamically create individual pie charts for each DeviceID using a matrix layout. While this approach is manual, it can work well for a small number of devices.
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
Hi @YumeenShahid ,
Unfortunately pie chart doesnt support the small multiples, this can be reached using bar or column charts.
I hope this reply was helpuful, if yes, please consider to mark as solution and give a Kudo
thank you.
Thanks
Hi @YumeenShahid ,
Pie chart does not have the ability to create small multiples by default.
One solution is to create a Pie Chart from SVG and then use that in a matrix - this will give you a similar result.
This can help you: https://www.youtube.com/watch?v=UxZQ8dOosyg
Resident Rockstar | Former Super User If I helped, please accept the solution and give kudos! Connect with me |
Thanks
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.