Dear All,
Can anyone help on below Matrix table visual requirement, I have 2 values count and values and i ploted in matrix table with state and city however the count and values are plotted as below.
However I need the visual as per below format, Please help on this.
Hi @121Balu ,
The native matrix visual doesnt have an option to group the columns by a certain measure first then followed by another. The closest you can get to with some advanced DAX is something as below. Attached is a sample pbix you can play around with. You may also submit this as an idea at https://ideas.fabric.microsoft.com/
Hi @121Balu ,
The native matrix visual doesnt have an option to group the columns by a certain measure first then followed by another. The closest you can get to with some advanced DAX is something as below. Attached is a sample pbix you can play around with. You may also submit this as an idea at https://ideas.fabric.microsoft.com/
Helpful resources
Join our Community Sticker Challenge 2026
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Power BI Monthly Update - January 2026
Check out the January 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
| User | Count |
|---|---|
| 62 | |
| 62 | |
| 42 | |
| 20 | |
| 18 |
