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 year = YEAR ( currentDay )
RETURN ROW (
"day", day,
"month", month,
"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.

Thanks.

 

 

 

 

 

Need Help

6 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    HI Divya904

     

    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 )
)
    • Divya904's avatar
      Divya904
      Helper III
      8 years ago

      Hi Phil,

       

      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,

      Divya

      • Phil_Seamark's avatar
        Phil_Seamark
        Microsoft Employee
        8 years ago

        Hi Divya904

         

        It seems odd.  I tried to replicate it here and it works ok for me up in the web service.

         

        I've attached a simple example PBIX file that I used.  Can you upload that and see if it does the same thing?