Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello
I need to place a date segmentation chart in Power BI, which is configured as between, so that among those date ranges that appear by default, the last 3 months appear but that all the data from previous dates can still be accessed. I've tried a few ways and none have worked for me so far. If anyone has a solution to this, it would help me a lot.
I have this data slicer chart:
The idea is that it allows me to always show the last 3 months that coincide in day and month, that it allows the user to select dates prior to this range without being grayed out, that it is dynamic, that is, as long as the last 3 months are shown in reference to the last date loaded in the database. For example, tomorrow it may be that the last date loaded is 16/4/2025 and in the first box it should come out the 3 months to that date, without disabling the dates prior to that range. Is it feasible to do it and if so, how do I do it? It is urgent.
Please share sample data (excluding sensitive information) in text format, along with your expected result and any relevant logic. For guidance, refer to
How to provide sample data in the Power BI Forum
If possible, upload a simplified .pbix file using this guide:
How to upload PBI in Community
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.