Combine two charts into one

Hi,

Create a Calendar Table with calculated column formulas of Year, Month name and Month number.  Sort the Month name column by the Month number column.  Create a relationship (Many to One and single) from the Date column of both Fact Tables to the Date column of the Calendar Table.  To the Xaxis, drag Year and Month name from t he Calendar Table.

Hope this helps.

hello fksng66 

have you set a relationship (month column) between those two tables?

I made a simple example below with exact same DAX as you used :

- without relationship - the result is sum-ed to all month

- with relationship (month column) - the result is depend on month relationship

Hope this will help.

Thank you.

fksng66 Okay, So basically you can use a date table and connect it to both the tables from where the data is coming, and use the x-axis columns from the date table, then your data will get filter according to your requirement.

To create a date table you can use below dax:

DateTable =
ADDCOLUMNS(
CALENDAR(DATE(2020, 1, 1), DATE(2030, 12, 31)),
"Year", YEAR([Date]),
"Month", MONTH([Date]),
"Day", DAY([Date])
)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!