Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |