Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |