topic X-Axis Custom Display of Start of the Each Month in DAX Commands and Tips

X-Axis Custom Display of Start of the Each Month

lkaneff — Mon, 21 Oct 2024 19:12:40 GMT

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.

Re: X-Axis Custom Display of Start of the Each Month

lbendlin — Mon, 21 Oct 2024 22:19:04 GMT

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

Re: X-Axis Custom Display of Start of the Each Month

Anonymous — Tue, 22 Oct 2024 02:28:35 GMT

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

Best Regards,

Wearsky

Re: X-Axis Custom Display of Start of the Each Month

lkaneff — Tue, 22 Oct 2024 14:34:33 GMT

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.