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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Two relationship between tables, issue when filtering

Dear PowerBI Community,

 

I am facing an issue when trying to build more than one relationship between several columns (I know that PowerBi allows to build only one, but I'm trying for a workaround). Basically, I have several tables (for instance one for value of Equity, one for Cash, one for Debt etc) that have two columns in common: CLIENT and DATE (every month-end of the year). My aim is to build one big matrix that can show for every client the different amount of equity, cash etc for a chosen date.

 

I have created a relationship between the column CLIENT in each tables. My issues is that I would like to filter the date (for instance choosing only the last month). When I filter for the Date, it works unfortunately only for the values from the Table where I choose the Date category, and not for the other values from the other tables. Consequently, I would like to create a relationship between dates, in order that when I filter for the Date from a table, it selects the same Date also for the values of all the other tables.

 

Any idea? I know that I could append/join the tables in just one big table in PowerQuery (also cause all the different tables have the same structure in terms of columns), but I would like to avoid that and keeps the single tables separated.

 

Thank you.

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous ,

 

You could use USERELATIONSHIP() function.

Please check the blog for more details.

Power BI Userelationship function with example - Learn DAX

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Thanks a lot for the help!

Anonymous
Not applicable

Hi @Anonymous ,

 

You could use USERELATIONSHIP() function.

Please check the blog for more details.

Power BI Userelationship function with example - Learn DAX

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.