Is there a date slicer visual that only select month?

[sunlaromi]

Hi everyone,

I'm looking for a visual that can select only month, similiar like this, but only select month.

Any idea where I can find a free one?

Thank you so much!!

[v-pnaroju-msft · Accepted solution]

Thank you, @rohit1991 , for your response.

Hi @sunlaromi,

As per my understanding, Power BI does not natively support a "between" style slicer for months. However, you may achieve similar functionality by utilising the Timeline Slicer custom visual.

Kindly follow the steps mentioned below for implementation:

1. Open the AppSource window, search for "Timeline Slicer," and select the visual developed by Microsoft.
2. Add the Timeline Slicer to your report and insert the required field into the slicer.
3. Configure the Timeline Slicer for monthly selection. In the format pane, expand the granularity section and set the granularity to "month." This enables users to select a range of months using a slider mechanism.
4. The Timeline Slicer inherently supports a "between" style selection for the chosen granularity. Users can click and drag the slider handles to select the desired range of months.

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.

Thank you.

[rohit1991]

Hi @sunlaromi ,

If you're looking to create a slicer in Power BI that allows users to select only a month, rather than a full date range, there are a few simple ways to achieve this without using paid or custom visuals. One common approach is to create a new calculated column in your date table that formats the date as "MMM YYYY" using DAX, which you can then use in a slicer to filter by month and year. Alternatively, you can use the built-in Date Hierarchy in Power BI, and just keep the Month (and optionally Year) levels in your slicer. Another method is to create a separate table that contains unique month-year combinations and use that as a slicer. All these options allow for clean month-level filtering while keeping your report fully interactive and native to Power BI.

Option 1: Create a Month Column

Create a calculated column in your date table:MonthYear = FORMAT('Date'[Date], "MMM YYYY")

Then use that column in a dropdown slicer or list slicer.

Option 2: Use Hierarchy

If your date table has a hierarchy (Year → Month):

1. Drag the date field into a slicer.

2. Use the down arrow and select “Date Hierarchy”.

3. Remove all levels except Month (and Year, if needed).

Option 3: Create a Custom Slicer Table

If you only want unique months (even across years), create a new table:

MonthSelector = DISTINCT(SELECTCOLUMNS('Date', "Month", FORMAT('Date'[Date], "MMM YYYY")))

Then use this in your slicer and relate it to your data model (if needed).

[sunlaromi]

Hi rohit1991,

Thank you so much for your reply!

Sorry, I did not make myself clear, my boss specifically wants a visual like the screenshot, using "between", instead of dropdown, list or any other style.

I tried all 3 options you wrote, but in the end, they all not using style "between".

Is there any other option maybe? Thank you!!