filter on page should not lead to include total unfiltered values in visual

[centroid]

Hi

I have a bar visual. The visual sums a variable over all employees for some years. Now I would like to see the same sum just for one particular employee. So I set a filter on the right hand side filter panel and this works finely. But if I insert the filter with the employees into the page, and then choose a particular employee from that filter on the page, then I get the following:

I know what it is doing, but that is my goal. I do not need the light area bars. Can someone help?

[vanessafvg]

you need to edit your interactions, so when you filter you are only left with what you are filtering on

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

[Syndicate_Admin · Accepted solution]

To modify the interactions between graphs or slicers you must do the following, I make you a step by step because that way it is better explained.

Step 1: Look for the graph or slicer that makes that graph filter that way.

Step 2: Click on the graph or slicer that was chosen in the previous point.

Step 3: We go to the format options of that visualization

Step 4: We click on edit edit interaction.

You must modify the type of interaction to be able to make it show in a different way.

If we modify it it shows in this way.

Which is what you need according to what I understand.

To turn off interactions to be viewed, click Format and edit iterations.

If this answer will help you, please mark as a solution.

Best regards