Power BI: Dynamic Date Slicer Behavior

[llealsantos]

Hey all,

I have a date slicer that filters the last 14 months using a calculated column in the calendar table. When the "Last 14 Months" is selected on the slicer, it correctly displays only the last 14 months. However, when deselected, I’d like the slicer to show available years instead of months.

Is there a way to achieve this dynamic behavior?

Thanks!

[v-prasare]

Hi @llealsantos,

As we haven’t heard back from you, we wanted to kindly follow up to check if the below solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

hi @llealsantos,m

As we haven’t heard back from you, we wanted to kindly follow up to check if the below solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

Hi @llealsantos, 

As we haven’t heard back from you, we wanted to kindly follow up to check if the below solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[techies]

Hi @llealsantos try creating dynamic bookmarks that allow users to toggle between

[Ritaf1983 · Accepted solution]

Hi @llealsantos 

If I understood your question correctly, one way to achieve this is by modifying or adding a calculated column in your calendar table.

The column should return "Last 14 Months" if the date falls within the last 14 months. Otherwise, it should return the year of the date.

Then, you can use this new column as the slicer instead of the date column. This way, when "Last 14 Months" is selected, it will filter accordingly, and when it's deselected, it will show years instead.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[AbimbolaArowolo]

If I got your question correctly, try creating a calculated column like this:

SlicerOption = IF([Date] >= EDATE(TODAY(), -14), FORMAT([Date], "MMM YYYY"), FORMAT([Date], "YYYY"))

Use this in your slicer to dynamically switch between months and years based on selection.

[parry2k]

@llealsantos maybe leverage field parameters to change the values dynamically.