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.

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
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.

SJ354's avatar
SJ354
Frequent Visitor
8 years ago

v-xjiin-msft

 

Hi Xi Jin,

 

I am experiencing the same issue since January update. Initially, the issue was limited to Power BI Desktop, so was waiting for it to get sorted by next update. But, I am still experiencing it after March update as well. Moreover, now my clients are also experiencing this issue on Power BI Service, however, everything is good at my end(Power BI Service). I am able to see "October 2017" in my slicers and filters.

 

Would really appreciate if you could please let me know why we are experiencing this issue and the time line when this will be sorted by Microsoft.

 

Thanks,

SJ