Forum Discussion

CostaBella's avatar
CostaBella
Frequent Visitor
2 years ago
Solved

Remove Duplicates

I have a report that I am working on that shows active Projects on Hurricane Evacuation routes. I use a slicer containing all the districts and counties. There are 3 tables connected to the slicer, 1...
Need Help
  • christinepayton's avatar
    christinepayton
    2 years ago

    Which visual are we talking about? Tables will only show duplicates if there is something different on the rows that it is showing, so if you have a table with the project ID and contact info, it will show one row per project ID with the associated contact info. If you removed project ID from the table, it would only show one row for the contact info for each contact. 

     

    You could use the slicer setting to force a user to select a value before data is displayed, maybe? Or remove the unique fields from the visual. Or use a matrix to group on the field that is causing the duplication for some visual separation. 

christinepayton's avatar
christinepayton
Most Valuable Professional
2 years ago

Which visual are we talking about? Tables will only show duplicates if there is something different on the rows that it is showing, so if you have a table with the project ID and contact info, it will show one row per project ID with the associated contact info. If you removed project ID from the table, it would only show one row for the contact info for each contact. 

 

You could use the slicer setting to force a user to select a value before data is displayed, maybe? Or remove the unique fields from the visual. Or use a matrix to group on the field that is causing the duplication for some visual separation.