Forum Discussion

Divya904's avatar
Divya904
Helper III
8 years ago

Remove timestamp from date

Hi Experts, I have created a date calendar using DAX as below:   Date = GENERATE ( CALENDARAUTO(), VAR currentDay = [Date] VAR day = DAY( currentDay ) VAR month = MONTH ( currentDay ) VAR ye...
Need Help
Divya904's avatar
Divya904
Helper III
8 years ago

Hi Phil,

Thanks for your prompt and sharing the .pbix file.

In your Date slicer, there is time as well. Please let me know how can we remove this time, so that we have just dates in the dropdown.

Thanks

 

Regards,

Divya

 

 

 

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

I'm not sure sorry.  It's interesting that it works fine for me.  It suggests a setting in your Power BI Tenant such as region, or locale

  • Divya904's avatar
    Divya904
    Helper III
    8 years ago

    I know, date formats works differenctly in different machines. This is because of Power BI desktop regional settings and Browers settings for Power BI web service

    I have set,

    Power BI desktop , regional settings to English Australia

    Web service setting is default Browser setting, which is English UK

    System language and Locale setting is English Australia

     

    Thanks.