Forum Discussion

shiner1's avatar
shiner1
Frequent Visitor
8 years ago
Solved

Line and stacked column chart

I'm trying to show year over year changes per month for shipments. When I select the same month for multiple years instead of showing the months side by side it totals into one month. Such as Septemb...
General Comment
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    shiner1

     

    Power BI chart visual only takes the category field you put on X-axis to aggregate the data. In this scenario, you have a Month Name column in your source table, Power BI can't detect the calendar based on this text column. I suggest you create a "Year-Month" column in your source table, and build a hierarchy like "Year->Year-Month". Then put the hierarchy into the chart and drill all level down to one.

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

shiner1

 

Power BI chart visual only takes the category field you put on X-axis to aggregate the data. In this scenario, you have a Month Name column in your source table, Power BI can't detect the calendar based on this text column. I suggest you create a "Year-Month" column in your source table, and build a hierarchy like "Year->Year-Month". Then put the hierarchy into the chart and drill all level down to one.

 

Regards,