cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sobek Frequent Visitor
Frequent Visitor

Visualizing data over time - more than 12 months

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-huizhn-msft Super Contributor
Super Contributor

Re: Visualizing data over time - more than 12 months

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]

1.PNG

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

Best Regards,
Angelia

 

4 REPLIES 4
Chihiro Established Member
Established Member

Re: Visualizing data over time - more than 12 months

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.

v-huizhn-msft Super Contributor
Super Contributor

Re: Visualizing data over time - more than 12 months

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]

1.PNG

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

Best Regards,
Angelia

 

nlsrsk New Member
New Member

Re: Visualizing data over time - more than 12 months

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

Capture.PNG

Chihiro Established Member
Established Member

Re: Visualizing data over time - more than 12 months

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

 

Ex: 2018-08

 

From [Date] column...

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