Reply
Frequent Visitor
Posts: 3
Registered: ‎12-06-2018
Accepted Solution

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 convert the date to format 101, the Timeline 1.10.3 slicer will no longer group the dates into Year, Quarter, Month, Week, Day as it was doing before I converted the date. 

 

Does anyone know of a way I can make the slicer work properly or know of a better date slicer I can use?

 

Thanks in advance!


Accepted Solutions
Community Support Team
Posts: 5,880
Registered: ‎09-21-2016

Re: Issue with Date Slicer

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.

1.PNG

 

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

2.PNG

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Community Support Team
Posts: 5,880
Registered: ‎09-21-2016

Re: Issue with Date Slicer

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.

1.PNG

 

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

2.PNG

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Posts: 3
Registered: ‎12-06-2018

Re: Issue with Date Slicer

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.