Forum Discussion
date filter not updated
Hi everyone,
I write this post, to demand your help about an issue that i'm facing, I created a cursor and the date animating this cursor is from a calendar table that i created in power query, with the debut date figuring in the photo below, and the limit is today's date, my report is published in power service and when i open it the morning i have to move the cursor to find out the date of today, can you please tell me how can i configure my cursor so that i get updated, the dataflow and model are updated at 3 AM every day. Can you please suggest me a solution not including to create another table because a lot of dependances and measures are related to the calendar table . Thank you in advance.
Hi. You can't let the slicer show today as last day configured. I can share two alternatives:
- If the analysis of the page is always for a start date untill today as last date of the calendar table, you can use an "after" slicer instead of a "range/between" one. That way you can always move the start date and the end will always be fixed for the last date of the calendar table.
- If you really need to let user move the last date, you can explore custom visuals at the app store. There might be slicer options for free that can help. I know this one was for preselected values but I don't know if it let's you build a range between dates: https://appsource.microsoft.com/en-us/product/power-bi-visuals/insiderscoop1611244107840.powerbi_customviz_preselected-slicer?tab=overview
I hope that helps
1 Reply
Hi. You can't let the slicer show today as last day configured. I can share two alternatives:
- If the analysis of the page is always for a start date untill today as last date of the calendar table, you can use an "after" slicer instead of a "range/between" one. That way you can always move the start date and the end will always be fixed for the last date of the calendar table.
- If you really need to let user move the last date, you can explore custom visuals at the app store. There might be slicer options for free that can help. I know this one was for preselected values but I don't know if it let's you build a range between dates: https://appsource.microsoft.com/en-us/product/power-bi-visuals/insiderscoop1611244107840.powerbi_customviz_preselected-slicer?tab=overview
I hope that helps