How to Create Filters in Matrix when user needs column name needs to be filtered

[Naveen_SV]

How can i create the Filters for the column which is given please see my below screen shot. when the columns are using Numbers. I want a filters for Male and Female is that possible.

[v-cherch-msft]

Hi @Naveen_SV 

You may try to use 'Unpivot columns' for Female,Male and Population columns in query editor.Then use the Attribute column as slicer.Attached sample file for your reference.

Regards,

[Naveen_SV]

Thanks for this update, I need one more solutoin is that possbile to get if i select Female i want to see male column blank and population column blank likwise other. Appreciate your help

[v-cherch-msft · Accepted solution]

Hi @Naveen_SV 

You may create a table2 as slicer.Then create 3 measures like below:

Female_1 = IF({"Female"} in VALUES(Table2[Slicer]),SUM(Table1[Female]))

Male_1 = IF({"Male"} in VALUES(Table2[Slicer]),SUM(Table1[Male]))

Population_1 = IF({"Population"} in VALUES(Table2[Slicer]),SUM(Table1[Population]))

Regards,

[Naveen_SV]

Your amazing thanks for this