Multiple Relationships

[Anonymous]

In Power BI, i have 3 different tables

Table A (Store Identity # only)

Table B (Stores Date wise sales & Identity #)

Table C (Store Date Wise Members registered & Identity #)

Now i wanted to show sale & Members in a graph which is why i created

Table A Store identity # - Table B Store identity #  (*.* Both)

Table A Store identity # - Table C Store identity # (*.* Both)

Clustered Column chart plotted.

Now i want to use the date as a universal filter like only one slicer but effecting all table accurately because now if i use date from Table B then it shows (Table B data correctly & Table C data's only total is correct), if i choose date from Table C then it shows (table C data correctly & table B data's only total is correct)

[nickyvv · Accepted solution]

Hi,

to be able to work with dates in Power BI the best way is to create a separate Date table.
That way you create a separate Date dimension on which you can filter correctly to filter your tables B and C.

You create both a relationship from table B and table C to the Date table. Please have a look at the link provided for more info.

[Anonymous]

Hi,

I have another query redarding relationships

There's this table A & B having *.1 relationship

Table C appended to Table A

Now do i have to create anyother relationship of table C or what?

Does it is automatically synced with table B for being appended in table A?