Forum Discussion
gilr1975
Helper I
Helper IPresent a chart only for a specific employee
Hello, I have a table with employees data: Emp.ID, salary, average salary. Emp.ID Salary Group Average Salary 100 1200 1500 180 1500 1800 230 2000 1700 I would like t...
Use a slicer for searching Emp.ID
Then write two measures
Salary=selectedvalue('Table'[Salary])
GroupAvgSalary= selectedvalue('Table'[Group Average Salary])
Use these measures in clustered column chart's values field.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
gilr1975Helper I
Helper I
Emp.Id - type number.
In slicer, I need to have a search and it works only with text.
Is there an option to use your solution via table and not slicer ?
nandukrishnavs
Community Champion
Community Champion
You can use this slicer for searching a number https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380859?tab=Overview
- gilr1975
Thanks a lot! It worked.