Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |