Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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,
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,
Your amazing thanks for this
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.