mahmed1
Well-known Member
- Joined
- Mar 28, 2009
- Messages
- 2,302
- Office Version
- 365
- 2016
- Platform
- Windows
Hi
i have a created a dashboard in power BI by having a Slicer and 2 charts (1 manager chart and 1 agent chart)
What i want to is when i change the Slicer to select an area manager - i want the manager chart to change to everyone who falls under that area manager and agent chart to change to everyone who fits under the managers
if i select a manager i want to filter the agents in that team however if i select a specific agent i want it to stay static and not change (I have cards set up to display the values)
At the minute everything filters through fine but when i select an agent it un filters the agents and i just dont know how to do it
ive tried several of ways but struggling to achieve this - can anyone help please...
thank you
i have a created a dashboard in power BI by having a Slicer and 2 charts (1 manager chart and 1 agent chart)
What i want to is when i change the Slicer to select an area manager - i want the manager chart to change to everyone who falls under that area manager and agent chart to change to everyone who fits under the managers
if i select a manager i want to filter the agents in that team however if i select a specific agent i want it to stay static and not change (I have cards set up to display the values)
At the minute everything filters through fine but when i select an agent it un filters the agents and i just dont know how to do it
ive tried several of ways but struggling to achieve this - can anyone help please...
thank you
