CODEWITHSUNDEEP
powerbi
Marcelo Gazzola
Marcelo Gazzola

Reputation: 1083

Why I can create these relationships?

I am trying to create three relationships between tables DATES - SALES - EXPENSES - PL to use a unique slicer from table DATES and filter the charts for SALES, EXPENSES and PL.

Although I can't create a relationship between SALES - DATES or EXPENSES - DATE. If I create the relationship SALES - DATES then I can't create the relationship EXPENSES - DATES. The same happens if I try to the relationship EXPENSES - DATES and SALES - DATES afterwards.

Below the message:

enter image description here

Upvotes: 0

Views: 22

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89361

You already have a Filter Flow path Dates > Expenses > Sort > Sales, and you can't have active relationships that create more than one filter flow path between tables.

One way to resolve this is to remove the bi-directional cross-filtering on the relationship from Sort to Expenses. Another is to have a separate copy of the Dates table to filter the Sales.

Upvotes: 0

Related Questions