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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
CK1
Regular Visitor

Vertically Stacked tables/ Matrix Visual

Hello!

 

Looking through other posts I have found similar questions to the one I have but not as a trended view. I am trying to create a visual like the one below in Power BI. The total volume & new patient data is located all in one table (New patient volume is decided by a column "New Patient?" with "Y"/ "N" values). This Volume table is linked to my Date table. The "New Patient %" is a calculation I have created to arrive at the percentage.

 

CK1_0-1725657030038.png

Is there a clean way to show all three sets of values vertically like this? Ideally I would like to add Year to Date and Last 12 Month calculations to the columns as well (I have these calculations created already).

 

Thank you for any insight!!

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Enable "Switch values to rows"

lbendlin_0-1725658037610.png

Accept that the Doc dimension will be on the outside  (it will provide better readability anyway), or you have to create a custom matrix design  (which is a much higher effort).

 

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

Enable "Switch values to rows"

lbendlin_0-1725658037610.png

Accept that the Doc dimension will be on the outside  (it will provide better readability anyway), or you have to create a custom matrix design  (which is a much higher effort).

 

Thank you! This worked for me, I appreciate the help!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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