Forum Discussion
How to set Slicer by Month for In Between Style
Hi All Power BI Experts,
Below is my simplified date and the slicer example. My data is presented in the format of year and month. However, the slicer given is in between by date, meaning I have to drag the slicer by date to choose the range I want it to show.
The issue I encounter is how I can set the unit/magnitude of slicer 'In Between' from date to year and month?
I have found that someone asked the similar question few years back. However, there wasn't solution provided due to limitation at that time. Hope that there is something to workaround it few years after now.
3 Replies
kelvin-lkh , Even if you want months between, You need to create a date using month year, so that it can work
The workaround
Select data between months - https://youtu.be/nEt7dT3Tfv4
amitchandak Thanks for the video link. However, that is not what I am looking for. I am looking for to cover the slicer betwen from date to month while maintaing the sliding option. Meaning that the sliding unit will be in 'Month' instead of 'Day'.
amitchandak wonder if you know any work around to achieve what I am looking for? thanks.
