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...
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

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

      • Smauro's avatar
        Smauro
        Solution Sage
        8 years ago

        Hi again v-haibl-msft

         

        I managed to strip down some data and the problem reappeared. The reproduction was easy: 1)have a datetime column, 2)add new transforming it to day, 3)add new transforming it to endofmonth. (All via queries) 



        Is filebin ok? https://filebin.ca/3gSJCrYni915/testpowerbi.pbix

    • BrianFleming's avatar
      BrianFleming
      Frequent Visitor
      8 years ago

      Another work-around is to set the X-Axis type to Categorical instead of Continuous