Urgent: Edit Interactions

[Anonymous]

Hi everyone, 

I have an urgent question. I have to present my dashboard first thing on Monday morning and I am a bit stuck here. 

My use case: I have a survey that was conducted to rate managers in our organisation, a global company. A manager has a certain set of demographics, 1. Department, 2. Function, 3. Location. I want to show 2]two graphs, the 1st graph only shows the managers results, so this is easy you select the manager and set the interaction to only show his results. The second graph, however, must show the results of managers in the same demographics as the selected manager to see how he compares to the other managers. 

How can the second graph filter and show the results of all managers in the demographics of the selected manager's demographics? 

Looking forward to the answer. 

Kind regards,

Edward

[v-juanli-msft]

Hi @Anonymous 

Is this problem sloved?

If not, please let me know.

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Do you like these visuals?

First visual only shows the selected value, second shows the selected one comparing with the whole.

default slicer is impossible to realize this, you could use a table visual or a custom slicer visual "Enlighten slicer".

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[edhans]

It would be helpful to see some sample data. 

You don't really need to change interactions. You want your first graph to cross-filter your second graph, but your second graph would have a measure that showed the demographics but had a filter to show ALL(TableName[Managers]) so it ignored the context filter of Managers but showed all managers instead.

[Anonymous]

Hi,

Thank you for your response, it sounds like you might be on the right track here, I am just uncertain of how to implement that. I have inserted a photo to give you an idea will this work for you?

Left graph filter by the manager, right-hand graph filter by the function, department and location of the manager for all managers in those areas.

[edhans]

No. I would need to see data not visuals. Tables with sample data, and an image of the data model for relevant tables.