Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a date slicer on a field that is set to data type date. The slicer will let me enter a from date but not a to date. It also won't let me use the slider. (I suspect the issues are related.) The little i says "data range not available."
I added a filter to the visual to not include blank dates, but that doesn't fix it.
Any ideas how to fix this?
Slicer:
Format of the field in the slicer:
When I try to click the slider button, it just keeps turning off.
I even made sure that there are no blank values passed to the slicer.
Solved! Go to Solution.
Hi @sp8 ,
I suggest you create a calendar table in your data model, please refer to https://kohera.be/blog/power-bi/how-to-create-a-date-table-in-power-bi-in-2-simple-steps/, create one to many relationship between your calendar table and fact table and use data column in calendar table for slicer.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
@v-deddai1-msft
Thanks. That's a nice workaround and technically makes the slider work as a slider.
It would work if I had fixed dates or was in import mode (which is not my situation), but it did give me the direction I needed to solve the issue.
Since I'm in Direct Query, I had to make an SQL query to generate the date table or else the import table would be stuck with whatever dates I originally put in since I don't ever do a data refresh.
One note in case somebody else wants to use this: you have to set up a 2-way relationship or else filtering by another field (like customer) won't allow the date slicer to adjust to an appropriate range and you'll end up with a huge reange with no resolution.
Hi @sp8 ,
I suggest you create a calendar table in your data model, please refer to https://kohera.be/blog/power-bi/how-to-create-a-date-table-in-power-bi-in-2-simple-steps/, create one to many relationship between your calendar table and fact table and use data column in calendar table for slicer.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
98 | |
96 | |
92 | |
78 | |
70 |