Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 57 | |
| 33 | |
| 33 | |
| 18 | |
| 16 |
| User | Count |
|---|---|
| 66 | |
| 65 | |
| 44 | |
| 30 | |
| 29 |