Slicer stops working at 3/14/18

[MathewIsherwood]

Hello,

I've got a real head scratcher here, i've read up a lot about slicers and had no problem with it up until this point. 

My slicer goes from 1/3/2017 to 4/6/2018 but the date stops working from 3/14/18 (usa date format).

If i use the slicer up until that date it shows perfectly fine, after that I get (blank). I've checked all the data tables and the data continues on as it should through that date until the end date but it just isn't being brought into the dashboard.

I've run out of ideas where to look for what might be broken, can anybody help?

Thank you in advance.

[v-juanli-msft]

Hi @MathewIsherwood

Could you try to “refresh” the slicer with date by choosing another visual and shifted back to same slicer?

Try different dataset to see if it still happens?

Does the issue occurs only service, what about desktop?

Additionally, you can refer to a similar issue, or you may open a support ticket

Best Regards

Maggie

[MathewIsherwood · Accepted solution]

Hello All,

After talking with support I have fixed my problem.

The field I had set as my primary key (source was from GA) would not update despite our attempts. I cloned the table (which worked fine) but then used a date table as my primary key and re-routed all my other tables to this one. 

All my graphs now work.