Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

i need to group measures in a matrix by a specific field.



when i select multiple year i want to show all measures together for comprison .

slection on Flter of FY year . i choose mulltiple year

Suppose Currently selected Multiple selection Filter - FY (2018 , 2019, 2020)



Example- Power bi dekstop result is this

Category  type2018 2019 2020 
 VolumeGrowth VolumeGrowthvolumegrowth 



Below what i want

Category  typeVolumeVolumeVolumeGrowthGrowthGrowth



Please Advice me 


Thanks in advance 






Super User IV
Super User IV

@Rajendrabobade , I doubt this possible unless you make measure as dimension.


refer to the similar solutions:


Or this blog from Greg:



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

I already read this post this not solution of my post , can you provide me another solution on this i just need all volume together on year basis  same applicabel for another measures 


below what i want 

Filter - 2017 and 2018 are selected in filter now. i just want volume together and groth togethr for comprison of data year on year in matrix tabel please advice me .


Cat typeVolumeVolumeGrowthGrowth


Community Support
Community Support

Hi @Rajendrabobade ,


You need to create a new table and new measures to implement it. I have created a sample. Please reference it to have a try.


  • Create a new table manually. (In my sample, they are a and b.)
  • Create new measures based on year and then drag them into values field of Matrix.




Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper I
Helper I

The solutions here are not practical. It is unbelievably pathetic that what is a simple thing in excel cannot be made equally simple in power bi. What the heck?!


Well, PowerBI and Excel are indeed different beasts (though PowerPivot is PowerBI's cousin)

You can achieve just about anything in terms of Matrix configurations. And yes, it requires some work.

here is an example of how to create a custom layout:

Hybrid or custom matrix 

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

Helpful resources

November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!


Power Platform October Community Highlights

Check out the top community contributors across all of the communities


Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors