Forum Discussion
How to create a custom slicer with two options containing range of dates?
Anonymous see attached, it is fairly easy to tweak from here. As a best practice, I added a date dimension in the model and added a column to identity dates before and after pandemic and then use this for slicing the data. Also for every date calculation, it is advisable to use date dimension and use a column from it to filter data, like on year, month date etc.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Super UserAnonymous It will be easier if you share pbix file using one drive/google drive with the expected output. Remove any sensitive information before sharing.
Link of the sample file which contains dataset
In this I want to create a check box type slicer containing two options (Before and after the pandemic). Thanks