Forum Discussion

junyetzotomayor's avatar
8 years ago
Solved

How to allow duplicate in the list

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?

  • 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 

1 Reply

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support

    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