Forum Discussion
April fools?
I am having the same problem, across multiple reports. I use week ending dates for most of my reports. And the last week ended on 1 April 2018. I can see the date in the data. And I can see the date in reports. But, if I try to filter (using a slicers) for that week - no data appears.
I also have data changing itself. A "End of Hour" (that matches a hour, and a date in other columns) is correct when viewed in Data, but adds a hour itself when viewed in Report.View in dataView in report
Well I'm pleased it isn't just me (though I'm sorry it's affecting you guys too!).
My reports are currently sourced from a single master table, which combines a myriad of stuff into an easily consumed data feed, so all I've done is add an extra field to the ETL process which delivers a text-based date instead of an "actual" date. This works fine (a bit of a pain to have to replace everywhere, but didn't take too long). A bonus to this method is not having to follow the PowerBI date types, so I can format the date however I like (e.g. something nice and short which doesn't take up lots of space).
I have wasted two days just to fix with zero outcome, whenever I try to run the dashboard for 1st April 2018, it ignores and does not bring any data. I tried replacing the value with some other future dates, it works fine but does not work for Ist April.
I am trying to filter txn_date within a table, it filters for rest dates except 01/04/2018.
Is it because of Day light saving causing this issue? This is impacting my BAU tasks, can anyone please assist?
Regards,
Rakshya
