Forum Discussion
Matrix report
It there a way to integrate that in the existing calander table
Hello Greg_Deckler ,
The suggestion that you gave will work, I might have to make few changes. I just wanted to see how to show all the 12 month by default. As if we select the pervious fiscal year. I am able to see all the month but when the current fiscal year is selected it will only show the month that have passed. I need that to remain static as I need the visual to remain in the same size. If you see the below screenshot. Which shows the data of the pervious 3 fiscal years. And the Last fiscal year is spread out in months.
If there is any suggestion regarding that.
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