Forum Discussion
Date Range Slicer between Dynamic Dates
I have a dimension Calendar retrieved via my source database. Its max date value is today's date.
I want to make a date range slicer (between) and the ranges must be dynamic. For instance, by default displaying the last 3 months but user can also expand the period. I tried with a derived column on the dimension, but it would only display the default period and can't expand more. A hidden filter too wouldn't solve it.
Limitation is I can't use the Power BI filter panel, so did we find a solution to this yet ? I'm really stuck.
Hello,
You can solve it by using a separate disconnected date table just for the slicer, then controlling what actually shows in visuals with a DAX measure, so the slicer always contains full range but default selection behaves like last 3 months. Another option could be using a relative date logic in a calculated table that still keeps all dates but adds a flag for default view, then use that only for initial filtering.
Best regards,
DanieleUse a relative date slicer. Set it to last 3 months. It updates automatically and users can still change the range.
5 Replies
Hello,
You can solve it by using a separate disconnected date table just for the slicer, then controlling what actually shows in visuals with a DAX measure, so the slicer always contains full range but default selection behaves like last 3 months. Another option could be using a relative date logic in a calculated table that still keeps all dates but adds a flag for default view, then use that only for initial filtering.
Best regards,
DanieleLimitation is I can't use the Power BI filter panelWhy not? It has all that functionality built in.
Use a relative date slicer. Set it to last 3 months. It updates automatically and users can still change the range.
Hi ahmadwljfksqlid,
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to DanieleUgoCopp & lbendlin & Kedar_Pande for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
Hi ahmadwljfksqlid,
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you
