topic Re: How to create slicer with categories in DAX Commands and Tips

How to create slicer with categories

GAURAV7781 — Thu, 17 Sep 2020 18:46:25 GMT

I have a categories

Re: How to create slicer with categories

CNENFRNL — Thu, 17 Sep 2020 22:31:43 GMT

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" )

Re: How to create slicer with categories

GAURAV7781 — Fri, 18 Sep 2020 03:25:00 GMT

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

Re: How to create slicer with categories

GAURAV7781 — Fri, 18 Sep 2020 08:23:12 GMT

I tried W, S & rest are working

only when i am select WS together not working CNENFRNL

Re: How to create slicer with categories

CNENFRNL — Fri, 18 Sep 2020 09:49:26 GMT

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.

Re: How to create slicer with categories

RobbeVL — Fri, 18 Sep 2020 21:30:25 GMT

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