Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys,
How to make my slicer correspont with another slicer which has inactive relationship between them.
I have one slicer, lets say Company, which already put as slicer :
Company |
DEMF |
BGR |
SME |
And then I have Worker Table like below:
Worker | Company |
Julie | BGR |
Garry | BGR |
Lisa | DEMF |
Matt | SME |
Sophie | SME |
I cannot put active the Relationship because it already connect with some other table, so im my Worker slicer now, it display all of them instead what already selected in Company slicer
Thanks,
Solved! Go to Solution.
Hi @admin_xlsior ,
We can create a measure and make the table visual filtered by the measure.
Measure = IF(MAX(Worker[Company]) in VALUES(Company[Company]),1,0)
Pbix as attached.
Regards,
Frank
Hi @admin_xlsior ,
We can create a measure and make the table visual filtered by the measure.
Measure = IF(MAX(Worker[Company]) in VALUES(Company[Company]),1,0)
Pbix as attached.
Regards,
Frank
Could you please tell me, what does mean by keeing that measure is 1 on the visual filters, how does it related inactive relationship
Hi @admin_xlsior ,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
Frank
User | Count |
---|---|
94 | |
79 | |
76 | |
64 | |
60 |
User | Count |
---|---|
108 | |
101 | |
77 | |
63 | |
61 |