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

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!