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.
Hi,
I'm creating a dashboard which shows the progress of employees in the company. We have two teams and the employees move between each company. I can create a report for each company but I want to create a joint report. I'm having some problems creating a slicer which combines in the employee names into one single slicer.
I have two rows with each employee name and I use them in a drop down slicer but I'm wondering if it's possible to combine the two columns and make one single slicer
This is an example of what I'm working with
Company 1 on the left, Company 2 on the right. I want to combine the visuals and silcers together into one single view/slicer. The visual are fairly straight forward, it's just the silcers I'm having problems with
Any help would be welcomes
Thanks in advance,
Mike
Hi michaelknight94,
According to your description, it seems that you want to use one slicer to control different visula from different table, right? If so, you could create slicer table like below
Table 2 = DISTINCT(UNION(DISTINCT(T3[name]), DISTINCT(T4[name id])))
Then create relationship between this table and other tables, then use this field in slicer to see whether it work or not.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @amitchandak
Here's the link:
https://www.dropbox.com/s/ojxkg7fj5rjdf1i/Acquisitions%20-%20Community.pbix?dl=0
Used to wrong terminology. I didn't mean merge two tables, I meant two columns within the same table. Apologies
Thanks,
Mike
My bad. This link should work now
https://www.dropbox.com/s/orkigqemlm2slnh/Acquisitions%20-%20Community.pbix?dl=0
Hi Michael,
Not sure what your data looks like but the simplest option to me seems to be combining the 2 tables in to one then basing your slicer on that. Would that be an option for you?
User | Count |
---|---|
79 | |
74 | |
42 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |