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

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

Hi,

 

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 
a1223322332
b133442332

 

 

Below what i want

Category  typeVolumeVolumeVolumeGrowthGrowthGrowth
 201820192020201820192020 
a12333322332
b1344332332

 

 

Please Advice me 

 

Thanks in advance 

 

 

 

 

 

5 REPLIES 5
Super User IV
Super User IV

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

 

refer to the similar solutions:https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795

 

Or this blog from Greg: https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

 

 



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
 2017201820172018
A1211
B2321

 

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.)
Volume
Growth
  • Create new measures based on year and then drag them into values field of Matrix.

4.PNG

 

 

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?!

@apatnola 

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

Announcements
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!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

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