Forum Discussion

ebyhr's avatar
ebyhr
New Member
9 years ago
Solved

Different date formats in X axis

I guess Power BI uses different logics about showing X axis between the two graphs. 

Do you have any idea to avoid the difference? (I don't want to convert from DATE to STRING)

 

graph agraph a axisgraph b axisgraph b axis

 

Thanks for reading and apologize for the Japanese.

Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi ebyhr,

     

    If you want the axis to be consistent, create your own date table and your own columns for Month and don't use the Auto-date hierarchy feature that you are using in the image.

     

    Do you have a separate date table?

2 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi ebyhr,

     

    If you want the axis to be consistent, create your own date table and your own columns for Month and don't use the Auto-date hierarchy feature that you are using in the image.

     

    Do you have a separate date table?

    • ebyhr's avatar
      ebyhr
      New Member
      9 years ago

      Hi Phil_Seamark,

       

      I hadn't used separated date table because this is just for sample demo.

      But  I tried your solution and resolved now ;)

      Thanks for your rapid responce!