Is it possible to use the slicer in a bar chart to get the average of the non filtered values?

[gioprava]

Hi, 

I am quite new to Power BI,  and I am having trouble in understanding if and how I can get to what I need.

I created a survey, where people can rate different insurance companies so I can get a bar chart like this one, where I can get the list of all of them.

The table behind is like this:

Question	Company	Vote
are you happy with this company?	insurance 1	5
are you happy with this company?	insurance 2	10
are you happy with this company?	insurance 3	6
are you happy with this company?	insurance 4	7
how fast are they?	insurance 1	5
how fast are they?	insurance 2	9
how fast are they?	insurance 3	6
how fast are they?	insurance 4	7
is the contract easy to understand?	insurance 1	5
is the contract easy to understand?	insurance 2	8
is the contract easy to understand?	insurance 3	3
is the contract easy to understand?	insurance 4	7

Now what I'd like to do is to add a slicer, where I can select only one company at a time, so that I can get two lines in my bar chart: the company I selected, and the average of all the other companies (so excluding the selected one).
So basically to get something like this:

I hope I gave all the info needed, otherwise let me know and I'll try to add whatever is needed.
Thanks a lot

Giovanni

[gioprava]

Uau! super quick in providing a solution! Thanks a lot, really!

[_AAndrade · Accepted solution]

Hi @gioprava,

I'm attaching a pbix file with my solution for your request.
I hope this solve your problem.