Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 type | 2018 | 2019 | 2020 | |||
Volume | Growth | Volume | Growth | volume | growth | |
a | 12 | 2 | 33 | 22 | 33 | 2 |
b | 13 | 3 | 44 | 2 | 33 | 2 |
Below what i want
Category type | Volume | Volume | Volume | Growth | Growth | Growth |
2018 | 2019 | 2020 | 2018 | 2019 | 2020 | |
a | 12 | 33 | 33 | 22 | 33 | 2 |
b | 13 | 44 | 33 | 2 | 33 | 2 |
Please Advice me
Thanks in advance
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:
Proud to be a Super User!
Paul on Linkedin.
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.
Volume |
Growth |
@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/...
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 type | Volume | Volume | Growth | Growth |
2017 | 2018 | 2017 | 2018 | |
A | 1 | 2 | 1 | 1 |
B | 2 | 3 | 2 | 1 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |