Line Chart time series x axis formatting - don't show year

[Anonymous]

Hello,

I'm looking for a method to not show the year on my line chart x axis when continuous. Right now, I'm plotting year over year data (each line is a year) over a jan 1 - dec 31st axis. Since the x axis doesn't actually have a year associated (it's just january 1 - dec 31, in general), I'd like to only show the months. However it seems that powerbi forces me to show year as well? no matter where I adjust formatting, this always happens. (see below)

The other option is to model the data categorically which can give me the formatting I expect, but since there are 365 dates in the series the chart ends up showing ~1/12th of the data and requiring scroll, which is not an option for me. If there was a way to set boundaries on a categorical chart, that would solve my problem as well.

[v-xicai]

Hi @Anonymous ,

You may create Month column like DAX below, then put the column onto Axis box of visual.

Month= FORMAT(Table1[Date],"MMM")

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-xicai ,

This creates a categorial time series that doesn't fit properly in a visual with a wide x axis, as is described in my original post. Do you know of a way around this? Continuous series fit the entire xaxis in the visual which is why I prefer them.

[v-xicai · Accepted solution]

Hi @Anonymous ,

Your demand is a good idea, while it is not supported to set conditional formatting for line and clustered column chart in Power BI currently. You can post your new idea in Idea Forum , to improve the Power BI.

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.