How to create slicer with categories

[GAURAV7781]

I have a categories

Categories

A

B

C

D

E

Desired category output is

A,B = Car

A,B,E=Bike

A,B,C,D,E=Plane

[CNENFRNL · Accepted solution]

@GAURAV7781 I have a coarse solution if I understand your issue correctly.

Measure =
VAR __selected =
    CONCATENATEX ( ALLSELECTED ( Categories[Category] ), Categories[Category] )
RETURN
    SWITCH (
        __selected,
        "AB", "Car",
        "ABE", "Bike",
        "ABCDE", "Plane",
        "Other option"
    )

[CNENFRNL · Accepted solution]

@GAURAV7781 I have a coarse solution if I understand your issue correctly.

Measure =
VAR __selected =
    CONCATENATEX ( ALLSELECTED ( Categories[Category] ), Categories[Category] )
RETURN
    SWITCH (
        __selected,
        "AB", "Car",
        "ABE", "Bike",
        "ABCDE", "Plane",
        "Other option"
    )

[GAURAV7781]

@CNENFRNL hi is there a way to make desired column as slicer . My user want to select car and bike as filter 

[GAURAV7781]

I tried W, S & rest are working 

only when i am select WS together not working @CNENFRNL WS Not woking

[RobbeVL · Accepted solution]

Hi ,

This is the least to say a creative solution to the problem! 🙂 
I'm pretty sure if you try "SW" instead of "WS" it will work.

If it doesnt, i'll help you with a different approach.

Regards,

Robbe

[CNENFRNL]

@GAURAV7781 I see many other viz on this page, thus the result of your Area viz is an integrated effects under all possible filtering on viz. Pls try this if you'd like to make Area viz independant of other filterings,

Measure =
VAR __selected =
    CONCATENATEX (
        CALCULATETABLE ( ALLSELECTED ( Categories[Category] ), ALLEXCEPT ( Categories, Categories[Category] ) ),
        Categories[Category]
    )
RETURN
    SWITCH (
        __selected,
        "AB", "Car",
        "ABE", "Bike",
        "ABCDE", "Plane",
        "Other option"
    )

Better to attach a mockup file for further debugging if the issue lingers.