Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Shreyu123
New Member

Select and enable slicer

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:

  Enable_Disable =
    var slicer2 = SELECTEDVALUE(Table1[Type])
    RETURN IF(slicer2="C",1,0)
 
 Disabing when D selected:
 
Shreyu123_1-1690907294470.png

 

Enabling when C is selected:

 

Shreyu123_0-1690907257609.png

 

Now i want to select A and enable the slicer when C is selected as below:

 

Shreyu123_2-1690907371406.png

 

 

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

1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

Hi @Shreyu123 ,

 

Your measure is correct. If you choose D in Slicer 2, there's no value in Slicer 1.

vstephenmsft_1-1691390749230.png

vstephenmsft_0-1691390700768.png

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.

vstephenmsft_2-1691390908968.png

vstephenmsft_3-1691390914888.png

 

                                                                                                                                                         

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.           

 

View solution in original post

3 REPLIES 3
v-stephen-msft
Community Support
Community Support

Hi @Shreyu123 ,

 

Your measure is correct. If you choose D in Slicer 2, there's no value in Slicer 1.

vstephenmsft_1-1691390749230.png

vstephenmsft_0-1691390700768.png

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.

vstephenmsft_2-1691390908968.png

vstephenmsft_3-1691390914888.png

 

                                                                                                                                                         

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.           

 

kpost
Super User
Super User

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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.