Forum Discussion
Matrix report
I am trying to create a report which shows the data of the pervious year data from the selected year in a slicer in a yearly format & the selected year data slicer in months.. For example: I sele...
It there a way to integrate that in the existing calander table
Anonymous If I'm understanding what you want correctly, I think that is just a bridge too far for the matrix visual to have columns kind of reorder themselves like that. Maybe, again, if you constructed your disconnected table and measure just right, maybe. I an thinking three columns in your disconnected table.
| Category | Sort | Year |
| APR | 1 | 2021 |
| MAY | 2 | 2021 |
| JUN | 3 | 2021 |
| FY 21 | 4 | 2021 |
| JUL | 5 | 2022 |
| AUG | 6 | 2022 |
| SEP | 7 | 2022 |
| OCT | 8 | 2022 |
| NOV | 9 | 2022 |
| DEC | 10 | 2022 |
| JAN | 11 | 2022 |
| FEB | 12 | 2022 |
| MAR | 13 | 2022 |
| ARP | 14 | 2022 |
| MAY | 15 | 2022 |
| JUN | 16 | 2022 |
| FY 22 | 17 | 2022 |
So basically you could contruct your measure that based on the slicer selection, let's say 2022, it only shows the months for 2022 and it shows all of the FY. If they select 2021 then it shows the 2021 months, etc.
It there a way to integrate that in the existing calander table