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 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
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |