Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ebyhr
New Member

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 agraph a axisgraph a axisgraph b axisgraph b axisgraph b axisgraph b axis

 

Thanks for reading and apologize for the Japanese.

1 ACCEPTED SOLUTION
Phil_Seamark
Employee
Employee

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?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

2 REPLIES 2
Phil_Seamark
Employee
Employee

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?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.