Forum Discussion
Drop Down list for column in table
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?
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
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- Ritaf1983
Super User
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
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.