Forum Discussion

mariliafredini's avatar
mariliafredini
New Member
7 years ago
Solved

Slicer - Using a values in table to slice visuals

Hello,   I have table that shows the genres associated with a movie (i.e Drama, Terror, Comedy). The movies have multiple genres associated with. I would like to slice my visuals using one main Gen...
Need Help
Tips and Tricks
  • v-anabat's avatar
    v-anabat
    7 years ago

    Hi,

     

    I have created a sample file with the details you provided. 

    Please check if this works for you.

    From the sample data you provided I have noticed there is delimter which seperating each Genere.

    So, I have split this column based on Comma delimeter and created another table which acts as a dimension table for your slicer.

    Related these 2 tables based on Movie name.

    -------------

    Another possible solution is you can duplicate the filed and unpivot it and use that Genere filed for slicer.

     

    Solution1:

     

    Solution2:

     

    Regards,

    Ananth

v-anabat's avatar
v-anabat
Microsoft Employee
7 years ago

Hi,

 

I have created a sample file with the details you provided. 

Please check if this works for you.

From the sample data you provided I have noticed there is delimter which seperating each Genere.

So, I have split this column based on Comma delimeter and created another table which acts as a dimension table for your slicer.

Related these 2 tables based on Movie name.

-------------

Another possible solution is you can duplicate the filed and unpivot it and use that Genere filed for slicer.

 

Solution1:

 

Solution2:

 

Regards,

Ananth