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

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

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

      Smauro

       

      Thanks for your PBIX file. I’ve reported it internally to Power BI Team: CRI 51216807
      I’ll post here once I get any update about it.

       

      Best Regards,
      Herbert

    • v-haibl-msft's avatar
      v-haibl-msft
      Microsoft Employee
      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

      • Smauro's avatar
        Smauro
        Solution Sage
        8 years ago

        Thank you v-haibl-msft ! :)

        I had already thought of that, and I did a workaround by finally making all my graphs either dependant on a separate Calendar or with a new column with the start of the month. All good in the end! Thanks again!