The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. 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
User | Count |
---|---|
85 | |
84 | |
36 | |
34 | |
32 |
User | Count |
---|---|
93 | |
79 | |
66 | |
55 | |
52 |