cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tyulio Frequent Visitor
Frequent Visitor

Slicer with YYYYMM showing wrong dates

Hi,

 

I have a date slicer with YYYYMM dates like this:

 

From 201601 to 201807

 

 slicer 1.png

 

But when I use the slicer, it shows dates from YYYY13 to YYYY99 until change the new year. But I don't have these dates in my date table, I only have from YYYY01 to YYYY12.

 

 slicer 2.png

 

Why Power BI are showing these values in the slicer if they don't exist?

 

Thanks in advance!

 

Regards!

 

 

 

3 REPLIES 3
Moderator v-viig
Moderator

Re: Slicer with YYYYMM showing wrong dates

Moved from CV topic to Desktop.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Super User
Super User

Re: Slicer with YYYYMM showing wrong dates

Is it actually formatted as a date, or is it formatted as a number? If it's the latter and you're using the range slicer this should be intended behaviour really

Tyulio Frequent Visitor
Frequent Visitor

Re: Slicer with YYYYMM showing wrong dates

Actually it's formatted as whole number. But if I change it to date, I don't find the correct format:

 

slicer 3.png

 

Any workaround to solve this problem?

 

Thanks in advance!

 

 

Regards!