Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
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.
These are the tables, I hope you can help me, thank you very much, nice day 🙂
You can drag the key column onto its related column in the other table.
You can use the "Manage relationships" dialog
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 104 | |
| 82 | |
| 72 | |
| 46 | |
| 35 |