Filtering across column headers?

[AMARSHALL80]

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.

[AMARSHALL80]

Thank you @v-yiruan-msft 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.   

[SushainKoul]

Hi @AMARSHALL80 

Welcome. Didn't you still get the solution u were looking for??

[AMARSHALL80]

Hi @SushainKoul  - having looked at it again i think it has - thank you.  

[SushainKoul]

Hi @AMARSHALL80 .Your Welcome. If u still don't get it or u r facing any problems in this or near future u can ask me.

[v-yiruan-msft]

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

[SushainKoul · Accepted solution]

Hi @AMARSHALL80

It is actually possible to do this, but I don't really consider it a "clean" way.

1. edit the query
2. duplicate the table you want to filter based on columns
3. select all the columns you want to be able to filter (using shift and or control)
4. right-click and select unpivot data
5. 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