Forum Discussion

Yariet's avatar
Yariet
New Member
3 years ago
Solved

Filtering Visuals using "drill up value"

Hello,

I didn't find anything on Google. Is there any way to select a row in a Matrix and filter all the other visuals not by using the related "up-drill" value?

For example:

 

+ Father1
    Child1

    Child2

+ Father2
    Child3

    Child4

 

I want to click on child 4 and use Father2 as a "filter" value for the other visuals, is there any way to achieve that?

Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Yariet ,

     

    You want to just click on Child4, but filter out the results for Father2, i.e. filter out Child3 and Child4, right?

    If so, I'm afraid there is currently no such feature.

    However, as a workaround, you can do this by creating a separate slicer table.

    Fields for slicer:

    Main table

    There's no relationship between tabls.

    Create the following measure as a visual-level filter. Put it into the visual-level filters and set up show items when the value is 1.

    Measure = var _sel=SELECTEDVALUE('Slicer'[Father])
return IF(MAX('Table'[Father])=_sel,1)

    The fields of the slicer are from the Slicer table. And the fields of the table visual are from the main Table.

     

     

     

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Yariet ,

     

    You want to just click on Child4, but filter out the results for Father2, i.e. filter out Child3 and Child4, right?

    If so, I'm afraid there is currently no such feature.

    However, as a workaround, you can do this by creating a separate slicer table.

    Fields for slicer:

    Main table

    There's no relationship between tabls.

    Create the following measure as a visual-level filter. Put it into the visual-level filters and set up show items when the value is 1.

    Measure = var _sel=SELECTEDVALUE('Slicer'[Father])
return IF(MAX('Table'[Father])=_sel,1)

    The fields of the slicer are from the Slicer table. And the fields of the table visual are from the main Table.

     

     

     

    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.