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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register 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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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