This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
I have below matrix visualizations. The total units is calculated accordingly but the non measure fields are not. The expected scenario is to have scenario B in terms of the results and the matrix layout as scenario A by having item attributes as values.
Scenario A
Customer - Cluster | Customer on rows
Item - Segment, Brand, Brand Line, Item and Tire Size on values (First)
Sales - Units
Scenario B
Customer - Cluster | Customer on rows
Item - Segment, Brand, Brand Line, Item and Tire Size on rows
Sales - Units
Many thanks for your support
Actually I cannot share a pbix since there a lot of data that I need to remove. This is the expeced result by placing all non numeric values on rows.
The same result with a table.
This is the expected resut and layout
Hi @gerardotrejogcg ,
I created a sample pbix file, please check whether that is what you want.
Best Regards
Hi @Anonymous
Actually this is the result I want to see but for some reason it's not reflected as is. I reduced the model and excluded sensitive data so below I share the same.
Hi @gerardotrejogcg,
I'm not very clear about your problem. Do you mean that the value of field Units in the matrix can't display the correct result when the setting is with Scenario A? Could you please your expected result with specific examples? It is better if you can provide your sample pbix file(exclude sensitive data). Thank you.
Best Regards
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 36 | |
| 33 | |
| 26 | |
| 24 | |
| 17 |
| User | Count |
|---|---|
| 67 | |
| 49 | |
| 32 | |
| 27 | |
| 22 |