Forum Discussion
Removing duplicates in report level
Hello All,
I have a table chart where I am showing agentname and tickets.
I see I am getting some duplicates agent names in the report.
I need to delete that in the report level only .(Not in tranformation data)
Could any one please help how to do
Hello Anonymous ,
this should be handled in transformation data or in the data source, but if you want check these solutions
https://community.powerbi.com/t5/Desktop/Remove-Duplicates-Report-View/m-p/2440959
https://community.powerbi.com/t5/Developer/Remove-duplicates-from-a-report/m-p/1583045If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
2 Replies
- Idrissshatila
Super User
Hello Anonymous ,
this should be handled in transformation data or in the data source, but if you want check these solutions
https://community.powerbi.com/t5/Desktop/Remove-Duplicates-Report-View/m-p/2440959
https://community.powerbi.com/t5/Developer/Remove-duplicates-from-a-report/m-p/1583045If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
v-jingzhangCommunity Support
Hi Anonymous
If an agentname has more than one tickets in your original table, this is the expected result when you select "Don't summarize" for "Ticket" field in the table visual. In this scenario, to display every agentname once, you can expand the drop-down arrow next to "Ticket" column in Values well of the table visual and select another appropriate aggregation type for it instead of "Don't summarize". Hope this helps.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.