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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.

MayPowerBICarousel

Fabric Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.