cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ReneevdWalt1990
New Member

1st of January is not shown in selected year

I've created a Datetable in PowerBI and connected it to my date field <StartDate> in another table. I've created a slicer on the <Date> field from the Datetable. However, if I set my slicer to 1-1-2021 to 31-12-2021, I don't get the 1-1-2021 <StartDate> line in my table, but if I set my slicer to 31-12-2020 to 31-12-2021 I do get the line of 1-1-2021 <StartDate>. Please see below.

 

Slicer set to 31-12-2020 to 31-12-2021

ReneevdWalt1990_0-1612346403718.png

 

Slicer set to 1-1-2021 to 31-12-2021

ReneevdWalt1990_1-1612346437347.png

Hope you can help!

1 ACCEPTED SOLUTION
themistoklis
Super User II
Super User II

@ReneevdWalt1990 

 

Have you checked if there are any other filters applied in the visual or page which may be preventing the date from showing correctly.

 

I suggest you create a new page and test the date slicer there (use just a date slicer and a table visual with dates only)

View solution in original post

3 REPLIES 3
timg
Solution Sage
Solution Sage

Hi Renee,

First, could you check if the mapping of these values is correct? You can do this by placing both the [date] and [startdate] column next to eachother in a table. when you look for de row with 1-1-2021 it should contain that same date in both columns. If correct, it should like similar to the image below. if there is something off in the mapping, you will probably see empty values in the startdate column.

1.PNG

themistoklis
Super User II
Super User II

@ReneevdWalt1990 

 

Have you checked if there are any other filters applied in the visual or page which may be preventing the date from showing correctly.

 

I suggest you create a new page and test the date slicer there (use just a date slicer and a table visual with dates only)

View solution in original post

There were indeed other filter applied to the page. Thanks for your help!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors