Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MiteshY
Frequent Visitor

ADDING COLUMN VALUES TO SELECTED PARAMETER

Hello All,  

 

I have one question and i am not sure is it possible in power bi or not.

 

There is a column of user name in table and i want to specify some criteria to it based on user selection.

 

Eg. Column name is user name and i have created one table name Selection.

 

I want to add user name to selection which i have made.

 

Suppose username is Cat and in selection there are 2 dropdowns Animal and Not animal.

So if someone selects Animal then value sholud be added to animal field in selection.

 

In this way i want dynamic value based on selection , 

 

PLEASE HELP, IF WE CAN APPLY THIS IN POWER BI OR THERE ARE SOME OTHER WAYS TO ACHIEVE.

 

Thanks.

2 REPLIES 2
BeaBF
Solution Sage
Solution Sage

@MiteshY 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

Thank you @BeaBF for your response.

 I have tried what you have said above, but i am not getting the desired output. It would be great if you can share sample file.

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors