Forum Discussion
Gopinath_iyer
3 years agoHelper II
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
| Red | Red |
| Red | Red |
| Red | Red |
| Green | Green |
| Green | Green |
| Green | Green |
| Green | Green |
| Green | Green |
| Green | Green |
| Green | Green |
1 Reply
- mahenkj2Solution Sage
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!