cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
beardsleys
Regular Visitor

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

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

2 REPLIES 2
Microsoft
Microsoft

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

beardsleys
Regular Visitor

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.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors