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
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
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 |
|---|---|
| 136 | |
| 96 | |
| 77 | |
| 67 | |
| 65 |
