Relationship issue between 2 tables (date columns)

[Anonymous]

Hi,

I am trying to plot open incidents + close incidents + backlog on a same graph.

I have 4 tables:

 - all incidents

 - open incidents

 - closed incidents

 - date

I created relationships between them as following:

Relationships INCT open/Date and INCT close/Date are working but INCT all/Date is not. (Active relationship is Opened Date/Date and non-active is Closed/Date.)

As a result, Customer and Assignment Group slicers (on the left of the image below) are blank, while I am trying to display the customer column and assignment group column of INCT all.

Every date type is "date" and "dd/MM/yyyy".

Have you got an idea?

Thanks

[Stachu · Accepted solution]

the relationships propagate from Date to INCT tables, but not the other way round. So e.g. INCT ALL will not propagate any filters to INCT OPEN

You would need to do one of the 2:
1) new tables listing unique customers with joins to the 3 fact tables, same for the Assignment Groups

2) append all 3 tables into 1, with additional column specifying original table name, the model is just 2 tables - Date and Union, as Customer and Assignment groups are in the same table they will act like one

[Anonymous]

I found were the problem came from, I had a time slicer and if I do not enter the start date as the minimal slicer date, I will have no data...

I do not know why now.

The problem is not solved, because I can see that when I put on a table indicator 'INCT all'[Opened date] and 'Date'[Date] columns:

Date column is empty for filled-in opened date

EDIT: I solved the problem by changing the column format (with Excel) in the csv I used before import it again in Power BI. Now 'Date'[Date] is well linked to 'INCT all'[Opened date].

By the way, is it recommended to set date table as "table date" (from the ribbon) ? Because it will erase the date hierarchy.

Thanks