Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Solved! Go to 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.
@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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |