Forum Discussion
Syncing two slicers/parameters
Hi AngeXu
The slicers can only filter each other, not "select" the value in another slicer like on the attached :but if you need to use the value of a second slicer according to the selection on the first one, it will work, for example formula
test = max('Table'[CLR])
will return the value of the second column filtered by the first onethe pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
1 Reply
- Ritaf1983Super User
Hi AngeXu
The slicers can only filter each other, not "select" the value in another slicer like on the attached :but if you need to use the value of a second slicer according to the selection on the first one, it will work, for example formula
test = max('Table'[CLR])
will return the value of the second column filtered by the first onethe pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly