Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
5 years ago

Calendar generation BUG

Why calendar generates wrong dates? tbl_PL[EndOfMonth] have maximum date 2020-09-30   But this measure generates good dates, but slicer show wrong dates until 2020-12-31 instead of 2020-09-30   ...
Need Help
Show and Tell
Tips and Tricks
v-robertq-msft's avatar
v-robertq-msft
Community Support
5 years ago

Hi, Analitika 

According to your description and picture, I created the data and measure and Slicer similar to yours, and I can also find this issue, I guess the reason is that you put the Date Hierarchy into the Slicer, if you change it to the origin [Date] column, it will be correct:

 

What’s more, for Date range Slicer, we usually use “Between” mode so that Date can be filtered intuitional. Here a blog explains why this issue happens some time, you can take a look:

https://blog.crossjoin.co.uk/2019/07/10/power-bi-slicers-show-values-that-do-not-exist/

 

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.

  • Analitika's avatar
    Analitika
    Post Prodigy
    5 years ago

    But i need hierarchy as it will not be slicer anymore without hierarchy