Forum Discussion

cnpdx's avatar
cnpdx
Helper II
9 years ago
Solved

X axis not aligned

The X axis months on my charts are not aligned with the bars. For example, "Jan 2017" is aligned under December data. And this will repeat itself next month and the month after. But with different months and newer data. Any ideas how to fix?

 

 

 

 

16 Replies

  • Baskar's avatar
    Baskar
    Resident Rockstar

    Cool dude,

     

    It is really miracle to see this am surprised.

     

    Can u please share the data to validate.

     

    My personal thinking : This is not possible to show like this.

     

    Note :

    U have to check with your data or relationship between.

     

     

    Let me know if any help.

    • cnpdx's avatar
      cnpdx
      Helper II

      not really comfortable sharing the file. but what kinds of possibilities do you see that could make this happen? im pretty sure my relationship between the dynamic date calendar and the sales table are correct. 

       

       

       


      Baskar wrote:

      Cool dude,

       

      It is really miracle to see this am surprised.

       

      Can u please share the data to validate.

       

      My personal thinking : This is not possible to show like this.

       

      Note :

      U have to check with your data or relationship between.

       

       

      Let me know if any help.


       

      • alanhodgson's avatar
        alanhodgson
        Solution Supplier

        Hey cnpdx,

         

        No need to share the file, but if you could share the relationship between the tables that would help. Also, how is the date column (used in the graph) formatted and what is the data type? Finally, I would look at the sorting on the date column, is it sorted by another column?

         

        Hope this helps,

         

        Alan

  • Even im facing the same issue.

    Have plot the Head count/Attrition (HR-Domain), but the FY which starts from April, but the X-axis is showing it as May, but tool-tip is correct, the first data point is from April.

  • same issue here, but when i switch to "categorical", it shows me the last day of the month.

     

    In this case, the 'date' column is a calculated column

    = coalesce(related(table1[date]),table2[date])

    Over November, we can see numbers from October and so on...