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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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
User | Count |
---|---|
98 | |
76 | |
74 | |
50 | |
27 |