Combinig 2 charts

Hi HuntBA2

Sorry for my bad statement, let me edit it again

1. firstly, don't keep any relationship between "workshop" and "workshop plan" tables.

create calculated columns in the "workshop" table

month1 = CONCATENATE(CONCATENATE(YEAR([invoice date]),"-"),MONTH([invoice date]))

month = CALCULATE(MIN([invoice date]),ALLEXCEPT(workshop,workshop[month1]))

invoice value per month = CALCULATE(SUM(workshop[invoice value]),ALLEXCEPT(workshop,workshop[month]))

2.create a new table with the "workshop" table

new table = SUMMARIZE(ALL(workshop),[month],workshop[invoice value per month])

3.edit relationship between "new table" and "workshop plan" table

then drag "date" and "plan" from "workshop plan" table, "invoice value per month" from "new table" onto the visual on the report.

Best Regards

Maggie