The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
246 | |
119 | |
114 | |
86 | |
70 |