Forum Discussion
Syncing two slicers/parameters
- 2 years ago
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
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
will return the value of the second column filtered by the first one
the pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly