Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello,
Within the last week or so, I've noticed that users can no longer type a custom date range within a slicer.
In the example below, users used to be able to type in "9/15/2021" and "10/15/2021" to see all timecards between September 15, 2021 and October 15, 2021. Now a calendar drop-down appears and you are forced to select a date on the calendar.
It is still possible to use the slider bars to select the date range, but most users in my company are accustomed to typing in dates into the two boxes and are frustrated this is no longer allowed.
Any help or suggestions would be greatly appreciated!
I've been able to enter a date if I right-click on the cell, but its iffy. Wonder if anybody has come up with a better solution.
does anyone have a fix for this? or a 3rd party solution?
Same issue - very annoying update. We are working with huge date ranges in our data (30 years +) so having to click through the years is extremely frustrating.
Having the same issue, following for resolution. Extremely annoying update!
I'm having the same issue.
Furthermore:
1. Used to be able to click on days in the prior month without having to click the up arrow to navigate to that month. Those dates are now "unclickable".
2. 4/3 represents the most recent date that we have data for in this particular report. If I click on 4/1 or 4/2, 4/3 becomes unclickable. I now have to switch months and then switch back for 4/3 to become clickable again.
It's frustrating. Something changed with how date slicers operate and now they are a pain to use.
@jglenntiger Can you update the Power BI Desktop version and try to publish again in the Service
we can able to insert the date in the slicer.
Download Latest Power BI Desktop
https://aka.ms/pbiSingleInstaller
The date slicer has been updated to a new version in a recent Power BI Desktop release. The new date slicer version allows manual entry or it allows you to pick from the calendar drop down.
Now, if you open a new (blank) report with a recent Power BI Desktop version and you add a date slicer to it, the slicer will work as described above (the most recent version of the date slicer will be added).
However, if you open an existing report (originally created with an old Power BI Desktop release) and you add a date slicer, the slicer will not work as described above (the old date slicer version will be added to the report). It will not work even if you open the existing report with the most recent Power BI Desktop release.
Is it possible to update date slicers created with old Power BI Desktop releases to the newest date slicer version?
I think the issue is that it works in the desktop but not on the service which is hugely frustrating. Anyone managed a fix or found this documentation in any release notes?
@Anonymous I downloaded the March 2022 release of Power BI desktop and re-published the report. Unfortunately, it is still not possible to enter dates in the slicer.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
36 | |
21 | |
18 | |
17 | |
10 |
User | Count |
---|---|
34 | |
33 | |
32 | |
19 | |
14 |