filter multiple SQL directquery views with one on page filter

[gazzap]

Hi

I have two separate SQL views, both contain the Close_Year and Close_Quarter, which are not unique, I want to add both sets of information to the same page and allow the data to be filtered, and visually changed from interacting with the panels that I add to the page. Trouble is I can seem to filter the two sources from the same filter. I can't join the tables as the data is not unique, and there are more than two fields to join. The data looks like 

Close_year, Close_quarter

2018            1

2018            2

2018            3

2018            4 

etc. 

Each view contains thousands of rows and contains both the Close_year and Close_quarter as int's. 

Any ideas ?

[Anonymous]

@gazzap,

Do you connect to SQL Server using Direct Query mode in Power BI Desktop? Do you create new tables that contain unique values and then create relationship among these tables? What is your expected visual after joining tables? Please post the expected result here.

Regards,
Lydia

[gazzap · Accepted solution]

Hi 

I am using directquery. Think I solved this myself, by creating two separate tables, Close_Year, Close_Quarter and linking to the other views, on the Close_Year and Close_Quarter fields, then filtering via the links. Thanks.