Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Slicer with YYYYMM showing wrong dates

Hi,

 

I have a date slicer with YYYYMM dates like this:

 

From 201601 to 201807

 

 

 

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.

 

 

 

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

 

Thanks in advance!

 

Regards!

 

 

 

3 Replies

  • jthomson's avatar
    jthomson
    Icon for Solution Sage rankSolution Sage
    8 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

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

       

       

      Any workaround to solve this problem?

       

      Thanks in advance!

       

       

      Regards!