Date Filter

[RafaelRolo503]

Good day,

In my report, my dataset was sincronized with my calendar. But, when i select the date in between 01/11/2020 and 15/11/2020 (or another day before), the day 01/11/2020 is NOT LISTED. However, when i select the dates in between 01/10/2020 and 31/10/2020, the day 01/11/2020 is LISTED. Consequently, brings errors in my measures. What's going wrong? 

This event happens only in november.

Thank you for support.

[v-robertq-msft]

Hi, @RafaelRolo503 

According to your description and picture, I created a calendar table and the main table like yours, but I haven’t entered your problem, like this:

Have you checked the single data cell of the date ‘2020/11/1’(Whether the field value of the two tables is consistent)?

If you stll have a problem, I suggest you can some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HotChilli]

It suggests a mismatch between the date table and the data table:

Here are some suggestions-

post the pbix so we can have a look at it (you can remove everything apart from the date table and main data date fields if you like)

add the calendar date field to the visual - see if the dates match up wrongly.

check that the calendar filters the data table (and not the other way around)

check there's no mismatch on datatypes.

[RafaelRolo503]

Good day, your suggestions are correctly on my report. Unfortunately...

[amitchandak]

@RafaelRolo503 The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

[RafaelRolo503]

I'm Brazilian, so Data in portuguese = Date in english 👍.

First, selecting the interval in november, the day 01/11/2020 is not listed.

But, when i select the interval in october, the day 01/11/2020 is listed.