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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
JustinZZ
Frequent Visitor

Displaying multiple values in a Matrix problem.

So I'm looking to display a matrix that shows each job a certain crew member has on a certain day, however with a matrix I can only show the first or last values. Is there any way for me to accomplish this in Power BI?

Untitled.png

 

 

 

2 REPLIES 2
v-xjiin-msft
Solution Sage
Solution Sage

Hi @JustinZZ,

 

First, please refer to @Greg_Deckler's link and share us more information about your requirement.

 

Then according to your description, to achieve your gole I think you can try Pivot. To make Date values as column names and use Table Visual to display the data. Go to Edit Queries -> Transform -> Pivot Column.

 

Reference: http://radacad.com/pivot-and-unpivot-with-power-bi

 

Thanks,
Xi Jin.

Greg_Deckler
Super User
Super User

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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