Forum Discussion
Advocate IMatrix - Only show quarters for specific years
Hi,
I've got a matrix with a date hierarchy in my columns, with measures switched to rows, giving me something like this...
| 2020 | 2021 | 2022 | 2023 | |
| Total Customers | 57,168 | 67,349 | 68,621 | 59,448 |
| Total Value | 6,562,063 | 5,929,856 | 6,140,753 | 4,212,423 |
I've been asked by my client if they can see the latest year split in to quarters, but still retain the historic years at just an annual view. Using the hierarchy, its easy to see each year by quarter, but trying various ways, I don't seem able to just view 2023 in quarters. Is this possible?
| 2020 | 2021 | 2022 | Q1-23 | Q2-23 | Q3-23 | Q4-23 | |
| Total Customers | 57,168 | 67,349 | 68,621 | 13,173 | 13,346 | 25,743 | 7,186 |
| Total Value | 6,562,063 | 5,929,856 | 6,140,753 | 1,935,900 | 865,521 | 1,009,112 | 401,890 |
Any guidance would be appreciated. Thanks.
not yet. Supposedly column expansion is in the works
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41
2 Replies
- lbendlin
Super User
not yet. Supposedly column expansion is in the works
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41
- satkin
That's a shame, but not a surprise. Thanks for the link to the idea, I'll be sure to upvote.
