Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

force select slicer value based on another slicer

hello, 

I'm not new to power bi at all, but I do have a question that I can't find any answer for.

 

so this is the case: 

I have 2 slicers - one is contract (which is a number) and the other one is ElectricSum (which is number too). 

 

let's say I have 2 contracts, one with 3 values on the electricsum and one with 1 value. 

 

I want when the user is choosing the contract with the 1 electric sum, the electricsum slicer will automatically force select the 1 value inside the slicer. 

 

I did a lot of thing in order to get that:

1) using chiclet slicer in the background - not helping because it is force select also the other one 

2) using bookmarks - didn't help because it is not dynamic 

 

any other option?

 

thanks a lot

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous,

    Could you please share sample data of your table here? It seems that you want to force default selection in ElectricSum slicer when chooing a contract value in the contract slicer and you don't want to manually select the value in the ElectricSum slicer, right? If so, as per my knowledge, there is no automatical way to achieve this. 

    As your post, you can use bookmark to work around this issue.

    Regards,
    Lydia