Forum Discussion
Need matrix column grouping
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 help me on this issue .
1 Reply
Rajendrabobade , This is not possible. You might have a try column header grouping approach discussed in the old solution
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
