Forum Discussion
Remove Duplicates
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.
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.
Thank you for the advice! Could you please explain how to go about setting up 2 of the 3 tables to wait to display data until criteria in the slicer is selected? I'm sort of new at Power BI so still learning what all it can do.
NVM! Quick DAX formula and I got it working!
Thank you for your help!