Drop Down list for column in table

[bslozano]

Hello!

Is there a way to have a drop down for a column in a table? For example, I have a list of about 10 different employees and I want to be able to choose one on the New Employee column. There will also be a distance column, and basically this would change when a different employee is chosen. So say I choose "John" as the employee from drop down, his distance would show in the distance column. Are voth of these things possible?

[Ritaf1983 · Accepted solution]

Hi @bslozano 
According to your description, you need to use a slicer.

Please refer to the linked guide:

https://www.spguides.com/add-a-dropdown-slicer-in-power-bi/

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Anonymous · Accepted solution]

Hi @bslozano ,

It sounds like you want to create a dynamic table that changes based on the selection of a drop down menu. You can try to use a slicer visual and a measure.

Drag and drop the Employee field from your source table to the slicer. This will create a drop down menu with the list of employees.

Next, you need to create a measure that calculates the distance for the selected employee. You can use the SELECTEDVALUE function to get the value of the slicer.

Distance =
CALCULATE (
    SUM ( 'Table'[Distance] ),
    'Table'[Employee] = SELECTEDVALUE ( 'Table'[Employee] )
)

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ritaf1983 · Accepted solution]

Hi @bslozano 
According to your description, you need to use a slicer.

Please refer to the linked guide:

https://www.spguides.com/add-a-dropdown-slicer-in-power-bi/

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly