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 there,
Probably a very simple question but I am struggling to find the best solution.
I have 6 tables which are identical (6 locations), imported from the 6 MS SQL data tables of the systems. In each table I have 2 fields:
- unique ID number
- enquiry date
I have created a date table and connected it with the enqury date of each of the 6 tables. I can now filter all the results on one date filter, which is great. However, how can I filter which location? I may want to compare location 1 and location 4 for example on a visual. Do I need to create a location table?
Thank you!
Solved! Go to Solution.
Hi @Anonymous ,
Not needed. Create one slicer with Location.Capture the selected Location value from Slicer using 'selectedvalue dax' in new measure and then filter the data for selected location.
Thanks,
Rupesh Dhage
Hi @Anonymous ,
Not needed. Create one slicer with Location.Capture the selected Location value from Slicer using 'selectedvalue dax' in new measure and then filter the data for selected location.
Thanks,
Rupesh Dhage
Hi @Anonymous,
Is this solution working for you?
Regards,
Rupesh Dhage
Hi @Anonymous ,
Yes, I would do so with a distinct in a common table like you did with the date.
Let me know if it worked, if so mark as solution.
BR,
DR
Hi @Anonymous
Thanks very much for your response. Would you mind walking me through the steps to achieve that?
Many 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 |
---|---|
104 | |
103 | |
87 | |
73 | |
66 |
User | Count |
---|---|
119 | |
111 | |
95 | |
79 | |
72 |