Forum Discussion

beardsleys's avatar
beardsleys
Regular Visitor
7 years ago
Solved

Issue with Date Slicer

Hope someone can help.   I am pulling data from SQL and I need to convert the date field to '101' in order to pull the specific (and distinct) records I need to import into BI.  However when I conv...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi beardsleys,

     

    How did you convert date to "101" format? Via SQL query before loading or via choosing the data type and format on the toolbar in desktop?

     

    After loading data into desktop, please check its data type.

     

    Also, please check the feild format you added to slicer.

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi beardsleys,

 

How did you convert date to "101" format? Via SQL query before loading or via choosing the data type and format on the toolbar in desktop?

 

After loading data into desktop, please check its data type.

 

Also, please check the feild format you added to slicer.

Best regards,

Yuliana Gu

  • beardsleys's avatar
    beardsleys
    Regular Visitor
    7 years ago

    I had to do it in the SQL query before loading it in, in order to obtain the specific data I wanted to load in Power BI. 

     

    I was less concerned about the format and more concern about obtaining the correct data.  The DB I am loading in can create multiple records for the same one that are only seconds apart, so in order to eliminate those duplicates I had to convert the date field to 101.