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
Rajendrabobade
Helper II
Helper II

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
apatnola
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.






v-xuding-msft
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.

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

 

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.