I have a table with two columns, for the sake of the example they'll be called Name and Date
Below is a sample of that table
| Name | Date |
| a | 1/1/2024 |
| a | 2/1/2024 |
| a | 3/1/2024 |
| b | 5/4/2024 |
| b | 5/5/2024 |
| c | |
| d | |
| e | |
| f | 6/6/2024 |
| f | 6/7/2024 |
I want to show only the Latest Date by Summarizing the column
But at the same time I don't want to hide the blank rows so my final table should look like this
| Name | Date |
| a | 3/1/2024 |
| b | 5/5/2024 |
| c | |
| d | |
| e | |
| f | 6/7/2024 |
Any suggestions on how to achieve that will be appricated.
Thank you.
Hello @samerhajjar ,
you add it to a table or matrix and you click on the drop down on the name field and check the show items with no data and the blanks will show.
Proud to be a Super User! |  |
Hello @samerhajjar ,
you add it to a table or matrix and you click on the drop down on the name field and check the show items with no data and the blanks will show.
Proud to be a Super User! | |
Helpful resources
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
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.
