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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
lkaneff
Frequent Visitor

X-Axis Custom Display of Start of the Each Month

 How do I get the formatting of the X-axis like this: 1/2008, 1/2009, 1/2010

It is displaying 2008, 2012, 2014.  That is not what I want.  Each data point represents the start of each month of the year  For example, 2008 will be Jan 1 2008, Feb, 1 2008 through Dec.  and that repeats for 2009, 2010 etc.  I'll upload my graph so you can see how the data is displayed.  X-Axis Display start of month skipped Years.png

2 ACCEPTED SOLUTIONS
lbendlin
Super User
Super User

At the moment you have no control over the rendering of axis labels for continuous date axis.  If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com

View solution in original post

Anonymous
Not applicable

Hi @lkaneff ,

 

I'm not sure if I understand your requirement. Do you want the x-axis to show 2018/1, 2018/2, 2018/3....
If my assumption is correct, please try this

vxiaocliumsft_0-1729564003751.png

vxiaocliumsft_1-1729564052506.png

vxiaocliumsft_2-1729564071284.png

 

 

Best Regards,

Wearsky

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @lkaneff ,

 

I'm not sure if I understand your requirement. Do you want the x-axis to show 2018/1, 2018/2, 2018/3....
If my assumption is correct, please try this

vxiaocliumsft_0-1729564003751.png

vxiaocliumsft_1-1729564052506.png

vxiaocliumsft_2-1729564071284.png

 

 

Best Regards,

Wearsky

The table that i'm joining to is a unique table.  I had a circular dependency when I joined my date table to the other table with my start date.  I appreciate your advice. I'm not sure there is a solution. 

lbendlin
Super User
Super User

At the moment you have no control over the rendering of axis labels for continuous date axis.  If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com

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.