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.

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

  • HanLee's avatar
    HanLee
    Helper I
    8 years ago

    This is currently what I'm getting. If I create a new report then it reverts to normal but that is very time consuming. So I was wondering if anyone else has encoutnered this issue before