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 Monthly Update - May 2026
Check out the May 2026 Power BI update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 61 | |
| 47 | |
| 27 | |
| 24 | |
| 19 |
