The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
In Excel pivot tables, when there are multiple Values to be aggregated, you can have those results displayed either displayed horizontally or vertically under each Column value. In BI's Matrix visualizaiton, I can certainly achieve the horizontal display - but can I achieve the vertical display? This vertical display is very useful in certain analyzes. Examples are below.
Regards,
--------------------
Rough Example - horizontal
Jan Feb Mar
Revenue Cost Margin Revenue Cost Margin Revenue Cost Margin
Customer A 10 7 3 15 8 7 20 16 4
Customer B 25 13 12 30 24 6 35 27 8
-----------------------
Rough Example - vertical
Jan Feb Mar
Customer A Sum Revenue 10 15 20
Sum Cost 7 8 16
Sum Margin 3 7 4
Cusotmer B Sum Revenue 25 30 35
Sum Cost 13 24 27
Sum Margin 12 6 8
Solved! Go to Solution.
Have you tried Format-->Values-->Show on Rows?
Many thanks. Simple solution - I just could not locate it. Appreciate the guidance.
Regards
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
79 | |
71 | |
48 | |
41 |
User | Count |
---|---|
139 | |
112 | |
72 | |
64 | |
62 |