Visualizing data over time - more than 12 months

[Sobek]

Hi there

I have sales data for more than 12 months back. I want to see all of the months (there are 15 months right now), next to each other (column chart). But BI Desktop is showing me only 12 months. 

What should I do to see all months on one graph?

Sobek

[nlsrsk]

Hi everybody, thanks for the solution above, it worked for me, BUT now I can't figure out how to make the x-axis display in the right order!?

I hope you can help out, thanks for being a great ressource.

/Niels

[Chihiro]

Typically, I just use yyyy-mm format to sort.

Ex: 2018-08

From [Date] column...

Year-MM = YEAR([Date]) & "-" & FORMAT([Date], "MM")

[v-huizhn-msft · Accepted solution]

Hi @Sobek,

As the @Chihiro said, you should use Year-Month column as X-axis level, please create the Year-Month calculated column using the formula.

Year-Month = Active[Year]&"-"&Active[Month]

If this still can not resolve your issue, please post more details, sample table or screenshot for further analysis.

Best Regards,
Angelia

[Chihiro]

What data type/column are you using as axis?

If you are using date hiaerarchy's Month as axis. This will cause issue.

To have more control over time intelligence. I usually create custom date table with Year-Month column.

Using that column as axis, you can show all months with data.