Forum Discussion
Helper IIIDate slicer issue - future dates greyed out, etc
I have a weird one. I have created several dashboard with widespread usage in my company. Today I had some complaints that people were unable to select their desired date ranges on the date slicer. What they noticed is that If they select a past date range, and then attempt to re-select a date range up to latest date's data (9th feb), the latest date is no longer selectable.
Proper behavior. The 9th (latest day of data) is selectable. Also I see that today's date of the 10th is in yellow text. And future dates are selectable.Incorrect behavior. Only up to the 8th is available , but there is data up to the 9th. Also today's date of the 10th is not in yellow text, and future dates are greyed out.
I thought that maybe switching some users to Admin priviledges may solve the issue (or at least give a clue to the problem). Nope. Made no difference. I seem to be the only one whose calendar slicer seems to still be working properly. These calendars had been working fine for a year up until this AM.
28 Replies
This is also now happening to me so I'm guessing it's to do with some update. I've made no changes to the report for months - use it daily to export some data and I noticed the issue yesterday. Came to the report today and can't select the 11th at all from the calendar - I had to manually type it in.
m_roussakisI wonder if MS is aware?
Hmm, not sure, I had a quick scan of the issues thread someone else posted and couldn't see anything on there.
Mine also had this issue! I unstalled Power BI and then re-installed the December 2021 version. Everything went back to normal with that version. There is definitely something glitchy with the February 2022 update.
- m_roussakis
I just had this problem re-occur today.
How I "fixed" it:
Delete date slixer and replace from scratch. Refresh and publish. Then it works again and I can select dates up until yesterday.Hi m_roussakis,
Thanks for your reply.
I have no problem finding a temporary solution as in my case I can just add an extra date table and make a relation to it.
But the current solution has just worked for several years where it has been possible to set the to-date on the slicer to a future date and it no longer works.It would just be nice to know if it was an intentional change or if we can expect it corrected.
- m_roussakis
I'm having this issue again. The weird thing is that on my desktop version, my calendar loads fine, all the way up until yesterday. However on the published version I can't select any dates in May 2022.
- amitchandak
Super User
m_roussakis , have you recently added a visual level filter or restricted calendar till today ?
Also, check any other user reported this issue - https://community.powerbi.com/t5/Issues/idb-p/Issues
- m_roussakis
There are no filters at all. No restrictions either. As I mentioned, my dashboard loads fine, I created it. But users are saying their calendars are now acting weird.
Hi m_roussakis ,
I have a test both on Power BI Desktop and Power BI service(report, dashboard, share with others), everything worked on my side
What's your PBI version, mine is Version: 2.102.622.0 64-bit (February 2022) ,the latest version. Please upgrade to this version and try again.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Mine seems to have resolved itself
Any updates. Mine is doing the same thing.
Mine resolved itself so maybe try applying any updates, refreshing browser, clearing cookies etc.
- m_roussakis
Well here we are, on May 19th 2022 and the problem has popped up again on one of my long standing dashboards. I can't get it to work at all.
Hi wrv505 ,
Glad to know that! Could you please Accept it as the solution to make the thread closed?Thanks in advance😀
Best Regards,
Eyelyn QinSorry, I'm not OP therefore cannot accept the solution on their behalf
