Forum Discussion
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 region to see clients to then see how those clients operate. That seems easy enough. But i want users to be able to select a region from a filter.
Unpivoting doesnt seem to help becasue i'm then not seeing the associated data.
I was thinking i would duplicate the table but i wasnt quite sure
Example Data
Intention
User filters on region to see how clients with that status are performing across different regions - so we can analyse regions, clients etc.
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
6 Replies
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
Thank you Anonymous and SushainKoul - really appreciate you coming back.
The unpivot is helpful and the duplicating of table seems to be getting me closer, but i dont it quite does what i am hoping to do (and i used regions just as sample data) - i would like to be able to filter on a Region and Status (e.g. USA Clients) to then show how those Clients (or other status selected) perform across other regions.
Hi AMARSHALL80
Welcome. Didn't you still get the solution u were looking for??
Hi SushainKoul - having looked at it again i think it has - thank you.
