Calendar Min and Max dates not reflecting on the slicer.

[Anonymous]

Hi Experts,

A weird issue, for some reason, the power query Dim Date created is not being evaluating for ages so I used the DAX 

DateTable = CALENDAR(MIN(TE_[Create Date]), MAX(TE_[Create Date]))

1. I am not sure why the power query date created radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-2-fiscal-columns  This worked for me for 3-4 reports no issues but today it won't 

2. Dax calendar created, could able to create a relationship to the Fact Table and but slicer is showing 

from 1/1/2003 to 2019 instead of latest date. The records exist (I have verified). 

3. When I clicked on From and To calendar and changed the dates, the KPI cards all gone blank in the range the records exist.  

I am now confused, 

If i move the TO slider to way back to 2006 or before there is no change in the KPI showing data but when I move the FROM slider, the KPIs go blank. Any one clue what mistake I am doing ?

[Anonymous]

I have no idea what is happening, I run the SQL again (tried actually to change the format, no matter I use Convert(date, <date>, 5 or 105 or any code) I get same output and data type is surely Date.  Anyway I recreated this and used power query to translate the date to local format and then calendar is showing the right dates.

[Anonymous]

@tamerj1 Thank you again. 

I had to check this for other issue and it is set to default Australia and this being my Organization controlled, this may not be the case but I will check this first thing tomorrow when I reach office. Let me know if there is any other things, I need to check?  

Thanks a lot

[tamerj1 · Accepted solution]

@Anonymous 

chech the regional settings of your computer