data aggregation

[Anonymous]

Good morning,
I have a question for you.
Why power bi when I have a field with which I want to add and have the total at the bottom aggregate the rows that are equal to me? Is there the possibility of having them distinguished?

For example I have:

instead I have:

Thank You

Best regards

[v-zhenbw-msft · Accepted solution]

Hello @tarz ,

Don't want to summarize and display Total?

If yes, we may use both ways to meet your requirements.

1. Add an index column and place the index column in the visual table configure not to summarize it.

2. The second way is to create two table visuals. One summarizes, another does not summarize. And put the table does not summarize on the top layer.

If you have any questions, please ask here and we will try to resolve it.

Best regards

Community support team _ zhenbw

If this post helps,then consider Accepting it as the solution to help other members find it faster.

BTW, pbix as an attachment.

[Anonymous]

Hi @v-zhenbw-msft

how can I create the index column?

Thank's

[Greg_Deckler]

@Anonymous - Try this:

1. Click on your visual. 

2. In the Visualizations pane, find your column TYPE in the Visualizations pane Fields list

3. Click the drop down arrow and select Do not summarize.

[amitchandak]

@Anonymous , Right click on the field in visualization Tab  use Do not summarize and try

[Anonymous]

Yes, if it doesn't summarize it works, but I would like not to summarize and have the total.