How to change month interval from 1 to 3 on x axis so it doesn't look cluttered

[OcelotSS]

Hi, I want the X axis to be less cluttered by showing the month name every 3 months, e.g. "January, April, July, October" instead of "January, February, March..." For some reason I'm unable to find anywhere to do this in PowerBI. I'm able to do this in Excel.

[MFelix · Accepted solution]

Hi @OcelotSS ,

In Power BI you cannot have the granularity of the x-axis set based on a higher value without having it on the axis, in this case you need to create a column on your data with the quarter start month, that way you can add it to your x-axis and have the values calculated accordingly.

[OcelotSS]

Thanks Felix!