Forum Discussion

Gopinath_iyer's avatar
Gopinath_iyer
Helper II
3 years ago

column filter like excel

Hi ,

 

can we filter a column in matrix view itself. e.g I want to filter the "schedule" column with Red only or Green. I dont want to use a slicer. Can we do it like MS excel where you can filter from the column header itself

Schedule Resources

RedRed
RedRed
RedRed
GreenGreen
GreenGreen
GreenGreen
GreenGreen
GreenGreen
GreenGreen
GreenGreen

1 Reply

  • mahenkj2's avatar
    mahenkj2
    Solution Sage

    Hi Gopinath_iyer 

     

    Possibly someone can point if this is possible to do, I would recommend to use slicer for this purpose, You can tweak slicer use a bit, e.g. you may make slicer as tab list instead of vertical list, or if you need so can add more than one column in slicer data.

     

    another way to filter is also cross filter with another visual.

     

    Your this column seems to be a dimension column, then it should preferably be used this way.

     

    Hope it helps!