Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Vertical display of values in a Matrix visualization

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Have you tried Format-->Values-->Show on Rows?

Show on Rows.png

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Have you tried Format-->Values-->Show on Rows?

Show on Rows.png

Anonymous
Not applicable

Many thanks.  Simple solution - I just could not locate it.  Appreciate the guidance.

 

Regards

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.