Forum Discussion
Solved
Filtering by column headings
Hi I have a range of columns with relevant data and would like to enable users of the reports to filter (using slicer or otherwise) by the column headers. They are participation figures so the da...
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
Can you post some image samples of what you have and what you want.
Thanks Matt, the data is very sensitive so I can't send it on, unfortunately.
Thanks for the help though.
It is very common to have sensitive data - normally 99% of the time. Most people just create sample data to explain the problem.