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
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
Thanks for that @TimGab.
Hey thank you very much for the solution but actually my new table with the unpivoted attributes has no relations with the other tables so the slicer of the attributes doesn't work. How can i do?
I tried to add also the column ID and i linked it to the other table but still nothing.
Hey thank you very much for the solution but actually my new table with the unpivoted attributes has no relations with the other tables so the slicer of the attributes doesn't work. How can i do?
I tried to add also the column ID and i linked it to the other table but still nothing.
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.
