create a slicer for unique and multiple value in a row

[flexcodec]

Hello, 
please i've two tables linked already in relationship this is my problem  i want to create a slicer that will filter b showing not only the unique value but also the value inside the list separated by a comma.

MARKER_TWO

NAME_ID	PARENT_ID	NAME_TITLE
10	2	MONDAY
20	5	TUESDAY
50	8	WEDNESDAY

MARKER_MAIN

NAME_ID	......	NAME_TITLE	...	...
10,20	....	MONDAY,TUESDAY	...	...
50,10,20	....	WEDNESDAY,MONDAY,TUESDAY	..	..
10	....	MONDAY	..	..
50	.....	WEDNESDAY	..	..

NOW THE 2 TABLES ARE IN RELATIONSHIP ALREADY.

NOW USE MY I APPLY MY SLICER TO FILTER THE NAME_TITLE PRESENT IN MY DASHBOARD  IN ONLY GET THIS:

(DROPDOWN)SLIDER = MONDAY

NAME_TITLE	...	...	...
	...	...	...
	..	...	...
MONDAY	..	...	...
	..	...	..

I WANT MY SLICER TO SHOW ALSO THE VALUE IN THE LIST SEPARATED BY COLUMN LIKE THIS :

(DROPDOWN)SLIDER = MONDAY

NAME_TITLE

MONDAY,TUESDAY

WEDNESDAY,MONDAY,TUESDAY

MONDAY

THANKS IF YOU CAN HELP ME.

[Ritaf1983]

Hi @flexcodec 

If the user only needs to select a single value from the slicer (e.g., "Monday"), there's a simple solution using a disconnected table and the SEARCH function in a DAX measure to filter rows that contain the selected value inside the comma-separated text field.

I've prepared a PBIX example to demonstrate this approach.

indicatior =

var selected_ = SELECTEDVALUE(slicer[NAME_TITLE])

Return

SEARCH(selected_,SELECTEDVALUE('Table (2)'[NAME_TITLE]),,0)

The pbix is attached

However, if multiple selection is required (e.g., selecting "Monday" and "Tuesday" together), it becomes significantly more complex. You would need to either:

• create a table with all possible combinations of the values (e.g., "Monday,Tuesday", "Monday,Wednesday", etc.),

• or dynamically split and normalize the values into rows and use intermediary relationships and advanced DAX logic.
  
  Both is veri complexed and recommend to consider just to split the rows , 1 row per weekday.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[ryan_mayu]

@flexcodec 

do not create relationship between two tables.

then create a measure

Measure = if( search(max('Table'[Name_Title]),max('Table (2)'[NAME_TITLE]),1,0)<>0,1)

add this measure to visual filter and set to 1

pls see the attachment below

[flexcodec]

Thank you your solution is perfect but the problem that am facing is it's removing all the empty rows in the column. 

please is there an way to filter without removing the empty rows but still doing the same thing ?

[ryan_mayu]

@flexcodec 

if you want to display the empty row ,you can try this

Measure = if( search(max('Table'[Name_Title]),max('Table (2)'[NAME_TITLE]),1,0)<>0||max('Table (2)'[NAME_TITLE])="",1)

[flexcodec]

Thanks for the solution but it's duplicationg the value on the whole table 

[ryan_mayu]

then could you pls update your sample data and the expected output?

[flexcodec]

SORRY BUT THERE IS NO DUPLICATED VALUE IT WAS A CONFUSION IT'S REMOVING SOME ROWS IN THE COLUMN.
EG: I'VE 0093 AS AN INDEX 
0093      MONDAY
0093      TUESDAY WEDNESDAY
0093      MONDAY,TUESDAY 

ONCE THE FILTER IS APPLIED IT'S REMOVES AUTHOMATICALLY ONE 0093 AND LEAVE 1. ONCE I REMOVE ALL THE VALUE ARE OK

[v-menakakota]

Hi @flexcodec ,

Can you please confirm whether the issue has been resolved or not. If resolved, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-menakakota]

Hi @flexcodec ,

We really appreciate your efforts and for letting us know the update on the issue.Please let me know if you have any further questions or if you'd like to discuss this further.

Thank you,
Menaka 

[v-menakakota · Accepted solution]

Hi @flexcodec ,

May I ask if you have resolved this issue?If not,please share the sample data. If it resolved , please share the solution here. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.