Forum Discussion
Solved
How to Create Filters in Matrix when user needs column name needs to be filtered
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.
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,
4 Replies
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,
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
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,