Forum Discussion

Sobek's avatar
Sobek
Regular Visitor
9 years ago
Solved

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 mont...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    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's avatar
Chihiro
Solution Sage
9 years ago

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.