Forum Discussion

Philthy's avatar
Philthy
Regular Visitor
8 years ago

April fools?

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 warehous...
Captain's avatar
Captain
New Member
8 years ago

I can confirm that we are also experiencing this issue.

I have noted that the issue seems to affect Slicers that are set to April 1st.

Not all kinds of date slicers seem to suffer the issue, however. I have noted that Dropdown and List do have the issue. Other types do not.

 

Notably, I do not experience the problem with setting the date by the Advanced Filter, but the Basic Filter displays nothing.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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