year over year comparison with column series

[mws5872]

On a basic chart you know how you can use the legend to show the split ( mix) of of the values in a bar chart. When using a line and clustered column chart you cannot do something similar. 

What I was trying to do is to create a YoY comparison for months with the line representing the delta % between previous and current ( this is easy and I have it done as of now)  look at the two graphics and think of how these would be combined. They want to see the YoY amount but they also want to see the mix change. 

[Ashish_Mathur]

Hi,

This seems doable.  Please share the link from where i can download your PBI file.

[v-danhe-msft]

Hi @mws5872,

Based on my test, I suggest you use a calculated column to show your YOY, you could refer to below steps:

Sample data:

Create a new table:

Calender = CALENDARAUTO()

Create a calcualted column:

YOY = var a='Table1'[Date]-365
var b=CALCULATE(SUM(Table1[Value]),FILTER('Table1','Table1'[Date]=a))
return b/([Value]-b)+0

Create a Line and stacked column chart:

You could also download the pbix file to have a view.

Regards,

Daniel He

[mws5872]

sorry but that is not what the client is looking for.

think of it this way 

2017 and 2018 ( year values) for total sales with the Py and Cy values stacked next to each other. Inside that total sales there are different categories say car types : Sedan, SUV, Luxury, Hybrid. We would want to see the amount of the total sales for each categories in the side by side bar chart. The line will represent the delta between 2017 and 2018 total sales growth/decrease

I hope that helps.

[v-danhe-msft]

Hi @mws5872,

Could you please share the pbix file if possible and post your desired result?

Regards,

Daniel He

[mws5872]

Sure! I could do that but the problem I couldnt get it to work at actually.

Basically its a mix bar chart plus using a line chart on top of it.