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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors