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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
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.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.