Forum Discussion

Smauro's avatar
Smauro
Solution Sage
8 years ago
Solved

Visuals displaying wrong time on X-axis

Hello all,

 

So, today (or at least today is the day I noticed) for some reason, my graphs show the wrong date on the X-axis. Whereas the values are, for example, August, it states september on the X-axis but on hover-up it does say August.
Incorrect Date on X-axis
The only filters applied are a relative date filtering for the last year.

Any idea why that is?

Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    8 years ago

    Smauro

     

    I’ve got response from the Product Team.

     

    By design. The Scalar axis is continuous/linear, and is automatically choosing best intervals. Monthly intervals are chosen, and default to 1st of the month. Imagine a scalar numeric axis - 10, 20, 30 are fine, you wouldn't expect 19, 29, 39 to be your value axis labels right? The Aug 31th column is plotted a few pixels left of the Sep 1st axis label in the repro screenshot.

     

    Best Regards,
    Herbert

10 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    8 years ago

    Smauro

     

    I cannot repro the same issue on version 2.51.4885.841 64-bit (October 2017) of PBI Desktop? Could you please make sure that you're using the latest one? If issue persists, could you please share your PBIX file which can be used to repro, so that I can have a try on my side.

     

     

    Best Regards,
    Herbert

    • Smauro's avatar
      Smauro
      Solution Sage
      8 years ago

      Hey v-haibl-msft . I just checked and I have exactly the same version. The problem still persists however. I should mention that the Date axis is monthly (one date per month) and not daily. Could this be the reason why PowerBI gets confused?

      I did it like that because I found graphing last x month with hierachy was almost impossible.. Always showing like that 

      (yes, I have no idea why 2017 December is even displayed in that one).

      So, back to the first issue. Do you think it may be a fault of the Month grouping? Should I try with a separate calendar?

      EDIT: Oh, I should mention as well that my filters are not slicers, they are page lever report filters. I don't know if this should make a difference, it shouldn't..

       

      EDIT2: So, I've found the reason. I had transformed the MonthOpen column to DateEndOfMonth so I could compute some monthly backlogs, and even if the value is, for example, 31/Oct/2017 the graph will put it close to the "continuous" November, hence all graphs end up showing this way.

      • v-haibl-msft's avatar
        v-haibl-msft
        Microsoft Employee
        8 years ago

        Smauro

         

        I just tired to add a DateEndOfMonth column and drag it into the chart. But I'm still not able to repro the same issue on my side. Could you please share a sample PBIX file which can be used to repro through online file service like OneDrive (You can use dummy data to create the report)?

         

        Best Regards,
        Herbert

  • Mycall65's avatar
    Mycall65
    Frequent Visitor
    3 years ago

    Any news on this?

    My graph is still showing the same issue, now 31st March 2023

  • vallemedef's avatar
    vallemedef
    Regular Visitor
    2 years ago

    Hi, 

    I met this behaviour today and, luckly, was able to solve it, at least for my case.

     

    I use following calculated column and use it for x-axis:
    MMM YY = EOMONTH('Calendar'[Date],0)
    And as result I got following chart:

     

    As you can see there are wrong labels on it.

     

     

    Changing the dates from End of Month to Begin of Month helped me here:
    MMM YY = EOMONTH('Calendar'[Date],-1)+1