Forum Discussion
date filter not updated
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
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