March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi all!
In the last few days, I'm experiencing strange behavior with date hierarchies on the service.
I have a report (which has been published for several years) with a simple 3 year DAX calendar, date added to the "stock" Power BI slicer, selected "Show All Levels" and deleted Year & Quarter... all good with desktop file. Published report to service and there is suddenly a "Blank" item contained within the filter.
I removed/replaced date in slicer of desktop file and republished without luck. I also tried editing report from service and simply selecting "Date Hierarchy" adds the "Blank" item... I scrolled through list of "non-hierarchy" dates and there were no blanks. 🤔
Any ideas?
TIA, Danny
Sorry for the late replies. Desktop file is fine... only happens on service. As a quick fix, I just added a global filter to exclude blank dates on all report pages.
Thanks, DannyD
Hi@musicbydannyd ,
You mentioned that you removed the Year & Quarter fields from the Dax calendar table, and it is possible that Month & Day may correspond to multiple values. It is recommended that you check the relationship between the tables.
If it is convenient, can you provide us with sample data so that we can help you solve the problem?
Hope it helps.
Best Regards,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Wow, this is exactly what I noticed in several of my reports, I thought it was just me
My hierarchy date slicer looks just fine in the desktop, but in the service I see as in the screenshot below
In my hierarchy slicer, I have year, quarter and month (from my date table), and I made sure I am only showing items with data
I do have two relationships (one active and one inactive) on my date table to my fact table, and I did find this article discussing inactive relationships and blanks in the date slicer, but I swear this wasn't prior behaviour (at least for blanks showing in the slicer😀)
HI @musicbydannyd ,
You mention that this is happening on the service, is it in the desktop as well? Do you have the date field being created as a measure or a calculated column? Are you joining the date field to another table that may have "blank" in it? Are you using the dropdown or the slider for the date slicer?
Proud to be a Datanaut!
Private message me for consulting or training needs.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
37 | |
22 | |
20 | |
10 | |
9 |
User | Count |
---|---|
59 | |
55 | |
22 | |
14 | |
12 |