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
FabCon & SQLCon – Barcelona 2026
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Power BI Monthly Update - July 2026
Check out the July 2026 Power BI update to learn about new features.
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.
