Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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
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
That's a shame, but not a surprise. Thanks for the link to the idea, I'll be sure to upvote.
User | Count |
---|---|
131 | |
71 | |
70 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |