I have created a date calendar using DAX as below:
VAR currentDay = [Date]
VAR day = DAY( currentDay )
VAR month = MONTH ( currentDay )
VAR year = YEAR ( currentDay )
RETURN ROW (
"year", year )
I have set the the date field format as dd/mm/yyyy and data type as text and created a slicer using this.
When publishing to web service, the slicer come up with date and time.
Please let me know how can i remove the timestamp in the slicer.
Maybe something like//
Date = GENERATE ( CALENDARAUTO(), VAR currentDay = [Date] VAR dayShort = FORMAT(currentDay,"dd/MM/yyyy") VAR day = DAY( currentDay ) VAR month = MONTH ( currentDay ) VAR year = YEAR ( currentDay ) RETURN ROW ( "day", day, "short day" , dayShort, "month", month, "year", year ) )
Thanks for your reply.
Tried the same DAX calculation that you have provided. But still getting the time stamp in the slicer.
Here is the screenshot from Desktop.
Thanks and Regrads,
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.
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
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