Forum Discussion

Galz's avatar
Galz
New Member
3 years ago

Help with "OR" condition between multiple slicers

Hey,

I've got 5 slicers for different categories,

I want to show the relevant records by "OR" condition between the slicers.

For example:

slicers: color-purple and product: ice cream and shape circle

result: all the ice creams and all the purple products and all the circles products.

I saw solutions only for 2 slicers- but i've got 5,

Thank you!

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Galz ,

    If the fields which applied on these slicers are from the same table or connected tables, it will adopt "AND" logic. This means that the feilds applied to the slicers need to be independent of each other. You can refer the following links to get it:

    Slicing based on OR and XOR conditions in Power BI

    Using OR conditions between slicers in DAX

    -- Example of bad table filter patter - try to avoid in your code!
OR #3 :=
CALCULATE (
    [Units],
    VAR Brands = VALUES ( 'Product'[Brand] )
    VAR Occupations = VALUES ( Customer[Occupation] ) 
    RETURN  
    CALCULATETABLE (
        FILTER (
            Sales,
            RELATED ( 'Product'[Brand] ) IN Brands
                || RELATED ( Customer[Occupation] ) IN Occupations     
        ),
        ALL ( 'Product'[Brand] ),
        ALL ( Customer[Occupation] )
    )
)

     

    Power BI slicer OR condition

    Best Regards