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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

sum of the rows total in matrix table

I have the data in matrix table it contains the each month of the data of particular variables, like below

  TYPE    jan  feb  march  april   

    a         1    2    3           5

    b         1    2    3           8

    c          5    2    3          10

 

how can i display the total of each row like,

TYPE    jan  feb  march  april   total

    a         1    2    3           5       11

    b         1    2    3           8       14

    c          5    2    3          10       20

 

I tried using measure, but no luck

Thanks

1 ACCEPTED SOLUTION
v-kelly-msft
Community Support
Community Support

Hi @Anonymous ,

 

1.Go to query editor>select column jan,feb,march,april >unpivot columns:

Annotation 2020-04-15 155735.png

 

 

 

 

2.Put "type" in Rows,"Attribute" in Columns,"value" in values:

And you will see:

 

Annotation 2020-04-15 162222.png

 

For the related .pbix file,pls click here.

 

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 

View solution in original post

2 REPLIES 2
v-kelly-msft
Community Support
Community Support

Hi @Anonymous ,

 

1.Go to query editor>select column jan,feb,march,april >unpivot columns:

Annotation 2020-04-15 155735.png

 

 

 

 

2.Put "type" in Rows,"Attribute" in Columns,"value" in values:

And you will see:

 

Annotation 2020-04-15 162222.png

 

For the related .pbix file,pls click here.

 

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 

amitchandak
Super User
Super User

@Anonymous ,

Better you unpivot the data

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

 

And then use it matrix visual

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

Top Solution Authors