Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.
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.
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
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |