Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi Team,
I have 2 tables .
Table 1 : A
Table 2 :C,D
I have created 2 slicers
Slicer 1 has values : A
Slicer 2 has :C,D
I am trying to enable/disable slicer1 based on selection from Slicer 2.
If C is selected in Slicer2,Slicer 1 will be shown/enabled.
If D is selected in SLicer 2, Slicer 1 should be disabled.
I have craeted a measure which is doing that:
Enabling when C is selected:
Now i want to select A and enable the slicer when C is selected as below:
I tried multiple ways but unable to do it.
Any help welp be really appreciated.
sample pbix file : https://1drv.ms/u/s!AjqH7k_M5ZVEhB3KilJmJISOSO4K?e=JfbO8P
Thanks
Shreya
Solved! Go to Solution.
Hi @Shreyu123 ,
Your measure is correct. If you choose D in Slicer 2, there's no value in Slicer 1.
If you have selected A in Slicer 2 before Slicer 1 is filtered, A will still exist after D is selected in Slicer 2, but if you cancel A, the Slicer 1 will become empty. This situation is by design and cannot be changed at present.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Shreyu123 ,
Your measure is correct. If you choose D in Slicer 2, there's no value in Slicer 1.
If you have selected A in Slicer 2 before Slicer 1 is filtered, A will still exist after D is selected in Slicer 2, but if you cancel A, the Slicer 1 will become empty. This situation is by design and cannot be changed at present.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Conditionally showing or hiding visuals based on logic is not possible at this time. You'll need to use bookmarks.
Hi,
Thanks for the reply.
I cannot use bookmark as i want the value to be selected based on the drop down value from other slicer.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
106 | |
102 | |
87 | |
61 |
User | Count |
---|---|
162 | |
132 | |
131 | |
95 | |
86 |