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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
JediMole
Helper II
Helper II

Understanding when to use a table over a matrix

As I move through my padawan training, I am trying to replicate reports our team uses for their QBR's with customers.  One of the slides has this 'table' and before I mess up my data, I wanted to see how I can make columns in the way they are used below.  I'm thinking I need to create a hierarchy of the status data to achieve this one, which brings me to the question, when should a table be used vs a matrix?  Are there better visuals for this kind of thing?  Keep in mind what I want to be able to do is publish these things to a dashboard so they can replicat them right into a PPT for later use

JediMole_0-1729775751410.png

 

1 ACCEPTED SOLUTION
audreygerred
Super User
Super User

Hi! You can achieve this on with a matrix.

Put your regions in rows. Put quarters in columns. Put the two meaures you will have in values.

 

Here is an example I made with sample data:

audreygerred_0-1729790488386.png

audreygerred_1-1729790524972.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

3 REPLIES 3
audreygerred
Super User
Super User

Hi! You can achieve this on with a matrix.

Put your regions in rows. Put quarters in columns. Put the two meaures you will have in values.

 

Here is an example I made with sample data:

audreygerred_0-1729790488386.png

audreygerred_1-1729790524972.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Glad to see what I was doing was correct.  Curious as to why the label only shows a number VS the word quarter, even if I change the name in the green box.  I'm assuming there's a label someplace I need to 'fix'

 

JediMole_0-1729796156246.png

 

Hi, you can add a column to your date dimension table that will hold the quarter name. 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Top Solution Authors