Forum Discussion

AngeXu's avatar
AngeXu
New Member
2 years ago
Solved

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 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

1 Reply

  • 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 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