Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

One Slicer for multiple columns

Hello Guys,   short question: How can I do a Slicer with multiple columns? Is there maybe a way with the hierarchie slicer?   If I do a single slicer for each topic, the user would get confused b...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, Anonymous 

     

    You can create a measure,then use in in visual filter pane.

    Like this:

    Measure =
IF (
    SELECTEDVALUE ( 'Table'[Topic1] )
        IN DISTINCT ( 'Table 2'[Topic1] )
            || SELECTEDVALUE ( 'Table'[Topic2] )
                IN DISTINCT ( 'Table 2'[Topic1] )
                    || SELECTEDVALUE ( 'Table'[Topic3] ) IN DISTINCT ( 'Table 2'[Topic1] ),
    1,
    0
)

     

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please upload some insensitive data samples and expected output.

     

    Best Regards

    Community Support Team _Janey

     

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, Anonymous 

 

Is your problem solved? The slicer is easy to achieve, the problem is what kind of visual effect do you want to achieve with this slicer, we don’t know.

You can try like this to get three columns' name:

Table 2 = UNION(DISTINCT('Table'[Topic1]),DISTINCT('Table'[Topic2]),DISTINCT('Table'[Topic3]))

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

 

Best Regards

Community Support Team _Janey

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    No my problem aint solved 😀

     

    Whats easy to achvieve for you, isn't that easy for me.

     

    A slicer should filter a table. As I wrote - I would like to filter the messages by the topics. If I do your solution with a new table. I do not have any relationship and the slicer wont work. 

    • v-janeyg-msft's avatar
      v-janeyg-msft
      Community Support
      5 years ago

      Hi, Anonymous 

       

      You can create a measure,then use in in visual filter pane.

      Like this:

      Measure =
IF (
    SELECTEDVALUE ( 'Table'[Topic1] )
        IN DISTINCT ( 'Table 2'[Topic1] )
            || SELECTEDVALUE ( 'Table'[Topic2] )
                IN DISTINCT ( 'Table 2'[Topic1] )
                    || SELECTEDVALUE ( 'Table'[Topic3] ) IN DISTINCT ( 'Table 2'[Topic1] ),
    1,
    0
)

       

      Did I answer your question ? Please mark my reply as solution. Thank you very much.
      If not, please upload some insensitive data samples and expected output.

       

      Best Regards

      Community Support Team _Janey