Forum Discussion
Gender Slicer for Different Columns
I have a table that already has gender summed for each row.
For example:
Course Male Female Division
-------- ------ -------- ---------
ABC123 5 10 Business
CBA321 7 3 Art
BCA231 10 15 Science
How do I provide a "gender" slicer that that you can select Male or Female and display the results?
You can create a Field parameter and add the gender column (or both if you have them separated) over there:
Go to Modeling tab in the ribbon menus and select New Parameter -> Field parameter
Then, drag & drop the fields from your right on the "Add and reorder fields" area:
Click Create.
Then, on your visualization, remove the Female and Male columns and include the parameter field you created.
And there you go!
1 Reply
- ray_aramburo
Super User
You can create a Field parameter and add the gender column (or both if you have them separated) over there:
Go to Modeling tab in the ribbon menus and select New Parameter -> Field parameter
Then, drag & drop the fields from your right on the "Add and reorder fields" area:
Click Create.
Then, on your visualization, remove the Female and Male columns and include the parameter field you created.
And there you go!