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 because he has to clean the checkmark each time he use a new topic slicer.

 

-> In this case I would like to have one Slicer which shows me in a table visualisation the correct messages - topics.

 

Goal:

 

 

Is there an easy method?

Thank you very much 😋

 

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

     

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous  You can use an independent table with values true and false as a slicer and use values into filter.

     

    the expected output is not very clear to me.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Sorry I did the wrong Screenshot, the first one should more like this one

       

  • 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