One Slicer for multiple columns

[Anonymous]

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 😋

[v-janeyg-msft]

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]

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 · Accepted solution]

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

[amitchandak]

@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]

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