column filter like excel

[Gopinath_iyer]

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

Red	Red
Red	Red
Red	Red
Green	Green
Green	Green
Green	Green
Green	Green
Green	Green
Green	Green
Green	Green

[mahenkj2]

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!