ADDING COLUMN VALUES TO SELECTED PARAMETER

Anonymous Hi!

Yes, it is possible to achieve the functionality you described in Power BI. You can use a combination of slicers and calculated columns to add the username to a specific category based on user selection.

Here are the steps you can follow:

1. Create a slicer for the "User Name" column in your table.

2. Create two additional slicers for the "Animal" and "Not Animal" categories.

3. Add a new calculated column to your table using the DAX formula:Category =
   IF(
   SELECTEDVALUE('Selection'[Animal]) = "Animal",
   "Animal",
   IF(
   SELECTEDVALUE('Selection'[Not Animal]) = "Not Animal",
   "Not Animal",
   BLANK()
   )
   )

4. Add the new "Category" column to your table visual.

5. When a user selects a username in the "User Name" slicer, they can also select either "Animal" or "Not Animal" from the corresponding slicer to assign the user to the selected category.BBF