Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Syndicate_Admin
Administrator
Administrator

Create relationships to apply filters

Hi, I'm new to power BI.
I am carrying out a project on a survey, data protection
I have three tables, one called "data" contains many columns, some of them have associated, a data type and / or a data holder, these two are the other two tables, what I need is to relate the columns of the data table, to a data type and / or a data holder to later create a filter, However I do not know how to do it, since I have tried several ways and I do not succeed. Normally to create a relationship is between columns, however the tables "data type" and "data holder", only have one column, with several rows. I also tried to create a table for each type of data each data holder, but it does not let me create the filter, I attach the screenshots, I hope they can help me.

rodlj_0-1683231300980.png

For example, the column named "DAI-Google Drive" must be related to the data type "DAI" found in the Data Types column of the Data Types table.

rodlj_3-1683231447952.png

rodlj_2-1683231431543.png

These are the tables, I hope you can help me, thank you very much, nice day 🙂

1 REPLY 1
lbendlin
Super User
Super User

You can drag the key column onto its related column in the other table. 

You can use the "Manage relationships" dialog

lbendlin_0-1683489969296.png

 

You can also enable the new relationship dialog and create/edit the relationships that way.

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors