Forum Discussion
Filtering by column headings
It is actually possible to do this, but I don't really consider it a "clean" way.
- edit the query
- duplicate the table you want to filter based on columns
- select all the columns you want to be able to filter (using shift and or control)
- right-click and select unpivot data
- now you can filter based on the new "attributes" column
Notice how this is not a good suggestion for large data as you have to copy the entire table.
It works though...
To actually implement the filter I would recommend using the chiclet slicer from the custom visuals store
I have the same issue. Time series data can't be filtered like such. I have large number of columns/indices and a date variable. I would've liked to see simple/yet very practical features like column filters added to the software.
It can be done.
You just need to go to "Modeling" -> New parameter -> Fields -> Drag the column (fields) that you want to include in the slicer into "Add and reorder fields" (Leave the "Add slicer to this page" option checked) -> Create.
Once you click Create, you will see the measure you just created in the right-hand data panel. Drag the measure to the visual values. The slicer you just created will now filter the visual columns based on the selected column name.