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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
dd88
Helper V
Helper V

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.