Matrix - Only show quarters for specific years

[satkin]

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.

[lbendlin · Accepted solution]

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.