Forum Discussion

mkrumpak's avatar
mkrumpak
Regular Visitor
9 years ago

Dynamic filtering question

Hi,   I would like to implement a slicer-like-control on a column that contains a list of values as shown in the example below, where item 1 has tags a, b, c, d, and e.   DATA SET item      tag ...
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

mkrumpak

 

In this scenario, you can create a calculated table first to aggregate the tags together.

 

Table = SUMMARIZE(Tags,Tags[item],"tags",CONCATENATEX(Tags,Tags[tag],","))

 

Then build the relationship between two tables, and set "Both" direction filter.

 

 

Now you can filter the expected result based on tag selection.

 

 

Regards,

  • mkrumpak's avatar
    mkrumpak
    Regular Visitor
    9 years ago

    Thank you for the reply.  

     

    I am not able to create a calculated table that matches yours.  When I use yor formula  Table = SUMMARIZE(Tags,Tags[item],"tag",CONCATENATEX(Tags,Tags[tags],",")), I get a table that matches the original table.

     

    When I create a table you described in the post manually, filtering works great!  Any chance you can elaborate on how to "unpivot" a row with a calculated Table?