How to set Slicer by Month for In Between Style

[kelvin-lkh]

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.

[kelvin-lkh]

@amitchandak  wonder if you know any work around to achieve what I am looking for? thanks.

[amitchandak]

@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

[kelvin-lkh]

@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'.