The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am building a report to show different data but for the same departments in my workplace. I have two excel work sheets that have the different data sets on them but I would like to have just one slicer in the report with a dropdown of the departments to select. Currently I have a slicer for each set of data. How do I link the data sets to have just one slicer?
Solved! Go to Solution.
Hi @DJN2911 ,
As per your description, I have created two tables which have country column.
1.Create a calculated table to get the country column.
Table 2 =
DISTINCT('financials'[Country])
2. Create a relationship between the tables.
3. Use the fields in the calculation table as slicers.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @DJN2911 ,
As per your description, I have created two tables which have country column.
1.Create a calculated table to get the country column.
Table 2 =
DISTINCT('financials'[Country])
2. Create a relationship between the tables.
3. Use the fields in the calculation table as slicers.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.