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.

  • HanLee's avatar
    HanLee
    Helper I
    8 years ago

    v-xjiin-msft I noticed that this is an option but then the months are not displayed in the correct order which is quite troublesome.

     

    I went ahead and changed to text and then back to date to see if that would work but that was unsuccessful.

     

    Another screen shot below which is what happens when I click on the filter with October displayed incorrectly. October is in there, but if I click another month, October disappears as if PowerBI has realised that data has been updated. October is also at the bottom which is odd as it should be in calendar order.

    • v-xjiin-msft's avatar
      v-xjiin-msft
      Solution Sage
      8 years ago

      HanLee

       

      But it works in my report. Please refer:

       

      Have you applied the changes for your report? Then for the order in the slicer, since the month column is a text column. So the order should be in text order not the calendar order which is like my above screenshot.

       

      Also, it will be more helpful to troubleshoot your issue if you can share us your report file (pbix).

       

      Thanks,
      Xi Jin.

      • HanLee's avatar
        HanLee
        Helper I
        8 years ago

        Hi Xi,

         

        sorry about my late response. I like having the calendar order and want to have that back. It looks a bit odd to have them in alphabetical rather than by the month.

         

        I cannot share the file due to privacy. Do you have any more ideas?

         

        Cheers,

        Han

  • 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

    • HanLee's avatar
      HanLee
      Helper I
      8 years ago

      He is not a dev so probably cannot give you a time window for this to be fixed. I've tried looking on the forum to answers to this question but I was unable to find any information about it.

      MS may be unaware of the issue right now so it may not be fixed for some time. It doesn't look like all users are experiencing the same problem we are.

      • SJ354's avatar
        SJ354
        Frequent Visitor
        8 years ago

        Thanks for the information. What should we do to make them aware of this issue. Do you have any email ID or something on which we can post our issue.

         

        Thanks,

        SJ