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

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more

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
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors