How to allow duplicate in the list

[junyetzotomayor]

Hi,

I have 'Users' table with duplicate Names but different email address. This is a valid scenario in the business.

But when I tried to put it in the attribute slicer, its automatically removing the other entry for "Vincent Chua".

Any thoughts how can I allow those 2 entries?

[v-qiuyu-msft · Accepted solution]

Hi @junyetzotomayor,

The Attribute Slicer will contain distinct values, but it doesn't affect filter different Email for the same "Vincent Chua" value. 

You can add another table visual into the report, place Users and Email columns. Select the value "Vincent Chua" in the Attribute Slicer, you will see two records return in the table visual. 

Best Regards,
Qiuyun Yu