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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Microsoft Employee
Microsoft 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
Microsoft Employee
Microsoft 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
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors