Table Fields are not getting grouped in Power BI

[Ramees_123]

I am using the below table view. My escalated number should get added based on the decision date and unit. 

Instead of having multiple rows, I need to make a single row grouped with decision date and unit with sum up escalated value.

How to do it ?

[v-kelly-msft · Accepted solution]

Hi  @Ramees_123 ,

Select the table visual,go to fields>click on the drop down button of "Escalated">choose sum:

And you will see:

Check my .pbix file attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[FrankPreusker]

You should use the matrix instead of the table visual to group rows in a similar way to a pivot table in Excel.