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
Anonymous
Not applicable

Measures as Matrix Rows?

Hi,

 

I've calculated a summary table using a dataset and have generated data that I'd like to visualise via a matrix. As seen in the img link below, the calculated table has four columns - KPI 1, KPI 2, KPI 3 and Date. 

 

I would like a matrix where the Date is a column header, each KPI has it's own row and the matrix values are the corresponding values within the summary table. I've seen this be achieved via unpivoting a standard query but I don't believe this is applicable with a DAX generated table. Furthermore, if I just create a simple matrix with just Date and a single KPI, the data is visualised how I would like (minus the missing row header), but when I add multiple KPIs it merges into the same row.

 

Power BI Summary Table and Example Problems 

 

Any suggestions?

 

Cheers,

 

Ollie

 

 

 

1 ACCEPTED SOLUTION
mahoneypat
Employee
Employee

Please check out the Show On Rows feature in the Matrix visual.

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2017-feature-summary/

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Anonymous , this is case for the show on row and date on column and nothing on row(group by)

refer how to do that

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

mahoneypat
Employee
Employee

Please check out the Show On Rows feature in the Matrix visual.

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2017-feature-summary/

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Anonymous
Not applicable

Thanks for the quick response - that's exactly what I was after!

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.