Forum Discussion
Solved
Filtering across column headers?
Hi there, I have a dataset which provides client status across a different field - sample data below where i've used region and my companies on the database. I want to be able to filter on a reg...
Hi AMARSHALL80
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
Hi AMARSHALL80 ,
I created a sample pbix file(see attachment) for you using UNPIVOT function, please check whether that is what you want. If no, please provide your expected result with backend logic and specifc examples. Thank you.
Best Regards