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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Nash2Bos
Helper I
Helper I

Grouping dates in a table

Hello all i have a table that looks like this 

 

date    | account name | amount 

1/2/24 | John Smith.    | $33.90

1/2/24| Amanda adams| $55.90

1/2/24 | Nick Johnson.  | $80.00

....plus more dates 

 

but i want the table to look like this 

date    | account name | amount 

1/2/24 | John Smith.    | $33.90

            | Amanda adams| $55.90

            |  Nick Johnson.  | $80.00

                               Total| $169.80

 

thank you in advance 

1 ACCEPTED SOLUTION
vicky_
Super User
Super User

Look at using a matrix visual with the stepped layout - https://www.popautomation.com/post/power-bi-matrix-to-tabular

You can additionally remove the +/- buttons in the formatting pane under the Row headers section.

View solution in original post

1 REPLY 1
vicky_
Super User
Super User

Look at using a matrix visual with the stepped layout - https://www.popautomation.com/post/power-bi-matrix-to-tabular

You can additionally remove the +/- buttons in the formatting pane under the Row headers section.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Kudoed Authors