How to use slicer on data separated with comma

[Hawkeye1]

Please, I have a situation where I have a column meant to collect day names separated with commas (Monday, Tuesday, Wednesday...)

How do I create a slicer to show records with a particular day name i.e. I want to make a slicer that would list Monday to Friday and any of the records with Monday would be available when selected.

Thank you @prvn @prvnkrs @amitchandak @Mikelytics @Migasuke @mangaus1111 

[HotChilli]

You can split the column by delimiter (comma)-> To Rows.

You would also create a Dimension table with the unique day names, then create a 1:many relationship from Dimension to the fact table.