Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
satkin
Advocate I
Advocate I

Matrix - 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...

 2020202120222023
Total Customers57,16867,34968,62159,448
Total Value6,562,0635,929,8566,140,7534,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?

 202020212022Q1-23Q2-23Q3-23Q4-23
Total Customers57,16867,34968,62113,17313,34625,7437,186
Total Value6,562,0635,929,8566,140,7531,935,900865,5211,009,112401,890

 

Any guidance would be appreciated.  Thanks.

1 ACCEPTED SOLUTION
lbendlin
Super User
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

View solution in original post

2 REPLIES 2
lbendlin
Super User
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

That's a shame, but not a surprise.  Thanks for the link to the idea, I'll be sure to upvote.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.