Forum Discussion

heidibb's avatar
heidibb
Helper IV
10 years ago

Issues Creating a Relationship

Hello,   Please see my model in the image below. I am trying to create a relationship between a few of these tables and a WEEK table.   My WEEK table has one column for WEEK with the values of 1 ...
Need Help
heidibb's avatar
heidibb
Helper IV
10 years ago

thank you CahabaData. I will search this, but my ultimate goal is to use week from my main WEEK table as a slicer to be able to filter my views that would include fields from multiple tables.

 

For example, when my slicer is selecting week 1, it will show data below for WEEK 1 only

 

WEEK                  |  ANNOUNCEMENT               |  FACULTY SCORE

from week table  |  from announcement table     | from faculty table

                               joined to week table                 joined to week table

 

 

I hope this makes sense.

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
10 years ago

heidibb

 

You can’t relationship into a “circle”. In this scenario, your table are in a star schema, you can add a week column in FACULTY table for each record, and create a relationship between FACULTY table and WEEK table. Then you should be able to use week column from WEEK table as a Slicer to get related data from other tables. 

 

Reference:

Create and manage relationships in Power BI Desktop

 

Regards