Date Slicer Extra Day

Question

I have Power BI Desktop (Version: 2.41.4581.361 64-bit (November 2016) connected to SQL Server 2016 via direct query.

I have a DateDimension with a field set as Data Type: Date and is stored in the database as a Date type.

When I use the Date Slicer an extra day is always added to the end date. I've profiled the data being sent to SQL server and it looks like a day is being added.

Screen Shot 1
Screen Shot 2

anonymous · Answer

If you look at screen shot1 I selected a data range of 12/1/2016 - 12/10/2016&nbsp;What happens on the screen is that it includes data from 12/1/2016 to 12/11/2016.&nbsp;I profiled the data and you can see in screen shot 2 that 12/11/2016 was passed in as the end date and as a result and extra daty is always displayed on screen.&nbsp;&nbsp;

tringuyenminh92 · Answer

Hi&nbsp;Anonymous,&nbsp;Hover on&nbsp;top right of slicers, you could switch to List or dropdown. With this option, the generated query will use one date with equal operator

anonymous · Answer

I know I can do that but I need a date range that works according to what's on the screen. &nbsp;The default setting says between. &nbsp;By the way the date range works correctly when the data is set to import instead of direct query.

tringuyenminh92 · Answer

Hi&nbsp;Anonymous,&nbsp;I'm sorry but It's confusing now. what's your expectation or concern? &nbsp;What is wrong with slicer behavior or query execution?

tringuyenminh92 · Answer

Yup Anonymous, azaming notice ^_^ maybe some guys in PBI team understands the business logic&nbsp;behind this behavior.

Forum Discussion

Date Slicer Extra Day

7 Replies

Related content

Between Date Slicer

Date Slicer

Date between slicer - Change order

Default Date for date slicer

Date Slicer not Responsive to Calculated Date Table