Logic of two columns in one slicer

[Orliktom]

Hello, 

I have a table where I have two true/false parameters for plan wheter it is "active" and "annual". Plan can be at the same time active and annual. I would like to make a slicer which will select active plans or annual plans. I mean if I select active it will show results where active is true - ignoring if it is annual or not.

Thanks

Tomas

[v-jingzhang · Accepted solution]

Hi @Orliktom 

You can create a table 'Plan Type' with only "Active" and "Annual" values in a column. Use this column in a slicer. 

Then create below measure as a flag. Put it in the filter pane on this table visual and set Value is 1. I attached a demo at bottom. 

Flag = 
IF (
    SWITCH (
        SELECTEDVALUE ( 'Plan Type'[Plan] ),
        "Active", SELECTEDVALUE ( 'Table'[Active] ) = TRUE (),
        "Annual", SELECTEDVALUE ( 'Table'[Annual] ) = TRUE ()
    ),
    1
)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[amitchandak]

@Orliktom , if you add two columns to the slicer, it will make a hierarchical slicer, it should divide it into two parts

or are looking filter slicer with each other, when they are not from same table ?

https://www.youtube.com/watch?v=cyOquvfhzNM

[Orliktom]

Hello, 

currently I have two slicers 

Active - True/False

Annual - True/False

Hierarchical slicer doesnt make sense, it would be better to have two separate filters. Im looking for solution to have slicer Plan - Active/Annual.

These are sample data:

Thanks

Tomas