Forum Discussion
data aggregation
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
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.
5 Replies
Anonymous , Right click on the field in visualization Tab use Do not summarize and try
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.
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.
