Forum Discussion

matdel's avatar
matdel
Icon for Helper I rankHelper I
2 years ago

FILTER Columns or rows in matrix visual

Hello

 

I would like to know if we can filter a matrix based on the value of a column or a row.

For example I would like to see only columns where the "Primary RM code" : 1024 is > 0 :

so it means that I won't see columns : 2404 / 2408/ 2409/ 2412/ 2423/ 2426

thank you!

Need Help

2 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    2 years ago

    matdel 

    Select the visual, on the Filter Pane, apply advanced filter on "Primary RM code" and choose "Greater Than" then provide the value 1024 .

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi matdel 

    You can not directly filter the field in the matrix, e.g  the value of 2404 / 2408/ 2409/ 2412/ 2423/ 2426 of 1024 are blank, but they are not blank for other RM codes, so they will display in the matrix.

    You can create a slicer and put the RM code field to the slicer, when you select the slicer,it will only dislay the related value and not display blank value

    e,g 

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly