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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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