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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
GJE
Frequent Visitor

Help to properly arrange values in an matrix

Hello everyone,

I hope someone here can help me with this.

 

I have a table which I want to display inside a matrix to get a view based on:

  • Columns = Month
  • Rows = Years
  • Values = consumption

No problem at this point! But I get stuck when I try to include a column -somehow- to display the total average per row -the sum of the values divided by the number of months-.

This is as far as I got, since the matrix shows me the correct data, I don't want to see the average column in each month, I just need the total average per month:

GJE_2-1693485142962.png

GJE_1-1693485119426.png

 

Table data example:

GJE_0-1693484789998.png

 

Expected result in Power BI matrix:

GJE_0-1693486059271.png

 

 

Any ideas are greatly appreciated, thank you.

 

 

 

1 ACCEPTED SOLUTION
ToddChitt
Super User
Super User

Unfortunately, I don't think there is a way to get a TOTAL column in a matrix without also including that value in the Column Breakdowns.

IT ( and this is a BIG IF) your matrix is not expandable on Rows (meaning: the rows are always shown without Expand/Collapse buttons) you can create a second matrix to the right of the first, add only that one Value, and the same column(s) on the Rows, and have the first matrix cover the left hand side of the matrix on the right. 

Not pretty, but it would work.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





View solution in original post

2 REPLIES 2
GJE
Frequent Visitor

Thanks Todd, I included a second matrix and that works well. 😁

ToddChitt
Super User
Super User

Unfortunately, I don't think there is a way to get a TOTAL column in a matrix without also including that value in the Column Breakdowns.

IT ( and this is a BIG IF) your matrix is not expandable on Rows (meaning: the rows are always shown without Expand/Collapse buttons) you can create a second matrix to the right of the first, add only that one Value, and the same column(s) on the Rows, and have the first matrix cover the left hand side of the matrix on the right. 

Not pretty, but it would work.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.