Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date Filter Calendar Block

It looks like the calendar visual has been updating in service (but not in desktop?). 


I love the visual updates and that it is greying out dates that don't have associated data, but the calendar is greying out the last date that has data unless I move the month back-and-forth.


I just made sure to update my Power BI Desktop and then republish the report to see if that solved the issue but no dice.


Here is what the calendar looks like before I toggle my month back-and-forth.




Here is what it looks like after I switch to either January/March and then back to February. I don't want my users to have to learn to flip the month to look at the most recent data like this.



Is anyone else experiencing this or know what is causing the issue?

Super User
Super User

Hi @Anonymous 


Could you please let us know what is the difference or issue in your 2 images as what you highlighted are available in both of them?

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

Not applicable

The first image shows the 10th greyed out. I can't pick that date until I toggle the month selected back and forth. The 2nd image shows it not greyed out, which is what happens after the toggle. Whenever the calendar is opened for the first time, that last date of data is greyed out as seen in the first image.

Ahh thanks for the explanation @Anonymous 


I think why this might happen is because the report is cached, and that is why when you toggle backwards and forwards it then refreshes the cache and then you can see the date?


Besides clicking in the refresh button I am not sure how to resolve this.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

Not applicable

I don't know what to make of it either. I've tried refreshing, but every time I freshly open the calendar, it greys out that date. If the issue was cahce related, I would expect that toggling it the first time would solve the issue moving forward. But if I close the calendar and open it back up, the behavior resets and I have to toggle again. It occurs on both the before and after date calendar box.


If this worked intuitively without the need to toggle, this would be great as it would be an visual indicator on what dates contain data. As it is, it's going to confuse users and drive them away from the most recent data.

Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors