Forum Discussion

HanLee's avatar
HanLee
Helper I
8 years ago
Solved

Inaccurate/Incorrect Month Appearing in Filter

Hi guys,   Just had something odd happen. So I recently updated Power BI and noticed that it's done some odd things to my filter by adding an extra "month" labelled 30 September 2017.   My data i...
Need Help
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    HanLee

     

    Thanks for sharing us your sample data. It helps a lot to repro your issue.

     

    Then for this issue, the newer version of Power BI desktop seems like will detect the text value automatically. And if the values are like date data, it will convert to date type automatically. You can verify this by checking at Edit Queries side.

     

     

    To resolve this issue, you can simply change the data type to text in above power query script in screenshot.

     

     

    Thanks,
    Xi Jin.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Please share the data file 

HanLee's avatar
HanLee
Helper I
8 years ago

I've shared the data file above. 

If I create a new report using the file it is fine, but creating the report again is very time consuming so I would rather not do it again

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Not able to access the file..could you upload to google drive

    • HanLee's avatar
      HanLee
      Helper I
      8 years ago

      I have updated the link with a googe drive link

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        I pulled out the month to the filter and this what am seeing