Combo Chart with multiple Lines and one Column instead of multiple clustered Columns and one Line

[ezabel]

I'm basically trying to combine both of these visuals. I want the total from the bottom matrix, as shown in the bottom line chart, to be the line in the top chart, if I make it a clustered column & line chart. These matrices are made from two different datasets, and I haven't been able to get them together.

[TeigeGao]

HI @ezabel ,

>>These matrices are made from two different datasets

You can try to create a standalone calendar table and create relationship between these tables, then create measures for these data you want to display.

Best Regards,

Teige