Ok - is someone at Microsoft having a giigle at my expense?
I work in health and have just received the new quarterly data for patients beginning April 1, 2018. I've imported it into my warehouse using the exact same routine which imports the last 3 years (at the same time), but when I update my reports, almost everything disappears when filtering for 1 April 2018.
It's WEIRD though. I can create a simple bar chart and see volumes by quarter (so April 2018, Jan 2018, Oct 2017, etc.) and have a pie chart that does the same thing, and an item which shows the overall count, and a table showing the data. When I click on ANY date except April in any of these visuals, everything filters accordingly (charts highlight my selection, overall count updates, etc.), but if I click April in ANY of them, it highlights NOTHING and my overall count turns to (blank).
I wondered if it was a FUTURE date causing issues. So I did a bulk update on the table to March 1. That fixed it. Updated back to April....broken. Started playing....1 Aug 2018 worked fine, so did tomorrow's date, so did 2 April. But as soon as it was set to 1 April again....boom.
Wasted a day tracking this down. No idea what to do. Having to introduce a completely new derived field in my processing and apply to every dashboard JUST to allow me to update my reports.
Anyone?!?!
