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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
dd88
Post Patron
Post Patron

Table column Year display only once

I have a Visual table with columns -  Planned Completion Year, Status, Totals

 

 

Table dates by year.png

 

 

how do I display the Year once, and then list all Status's for that year. For example this layout which is visually cleaner & simpler

 

2023 - Behind Schedule     1

            In Progress             2

            Yet to commence   1

 

 

In Columns, I select the field, and couldnt find a property that 'grouped'  'Planned Completion Year'

 

TIA

2 ACCEPTED SOLUTIONS
Gabry
Super User
Super User

Hello @dd88 ,

I don't think that is achivable with the standard table visualization.
You can achive a result like this with the matrix visualization

Gabry_0-1723186288578.png

 

 

If this help don't forget to kudos 😉

View solution in original post

qqqqqwwwweeerrr
Super User
Super User

Hi @dd88

 

In this table view it is not possible:

 

qqqqqwwwweeerrr_0-1723186723922.png

In matrix, there are mulitple option avaibale if you want to you explore you can check these option.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards

 

View solution in original post

2 REPLIES 2
qqqqqwwwweeerrr
Super User
Super User

Hi @dd88

 

In this table view it is not possible:

 

qqqqqwwwweeerrr_0-1723186723922.png

In matrix, there are mulitple option avaibale if you want to you explore you can check these option.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards

 

Gabry
Super User
Super User

Hello @dd88 ,

I don't think that is achivable with the standard table visualization.
You can achive a result like this with the matrix visualization

Gabry_0-1723186288578.png

 

 

If this help don't forget to kudos 😉

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors