Highlighted selection does not filter across visuals -independent filters on each visual also exists

[kyrpav]

I can not find a better title. if someone can suggest something i will change it.

I have a table with 4 columns. Class, Year ,Student , Grade,

For 3 different classes (Math, Biology, Chemistry) i am creating a bar graph where on X axis i have Year and in values i have Grade as average of all students.

So for these 3 visuals on the Filter panel i have added the Class and i have filtered them with different selection of one different Class for each visual.

When i select on any visual a Year i was expecting that this will highlight the same year in the other visual. What it does is that it unhilights at the rest visual everything and gives zeros to the values.

I understand that each visual is filtered with some class and when i select year 2020 in visual for Math then the rest visuals have no data cause these are filtered for other classes.

How can i make this work  without external slicers? 

[jdbuchanan71]

If you have the Year field in the legend you can click on just the year rather than the bar with is the combination of the year and class.

[kyrpav]

I am using a function to automatic color the bars so i can not use legeng. Any other possibility?

[jdbuchanan71]

Do you have the year on an axis?  If so you can click on the axis label rather than one of the bars.

[kyrpav]

Year is on X axis. Selecting on the year itself or on the bar has no difference i get the same result. As i said it seems that when i select the year of the graph i am not filtering only for year the rest visuals but for year and specific class. And there the rest of the visuals have no values.

[jdbuchanan71]

Can you share a picture of your graph?

[kyrpav]

I could also sent the pbix but i do not know how to insert it to the response.

So no selection all bargraphs:

And when i select 2019 in Chemistry's bargraph:

[jdbuchanan71]

You can upload your file to OneDrive or DropBox and share the link here.  When you click on the year in 1 chart are you just wanting it to highlight the same year in the other charts?

[kyrpav]

Yes exactly i select the year in barchar and then it should highlight the same year in other 2 visuals

[jdbuchanan71 · Accepted solution]

@kyrpav 

You will need to write measures that override any filter on the class.

Avg Math = CALCULATE(AVERAGE(Sheet1[Grade]),Sheet1[Class]="Math")

Avg Chemistry = CALCULATE(AVERAGE(Sheet1[Grade]),Sheet1[Class]="Chemistry")

Avg Biology = CALCULATE(AVERAGE(Sheet1[Grade]),Sheet1[Class]="Biology")

The top 3 are your old style, the bottom 3 use the new measures:

[Anonymous]

Hi @kyrpav ,

Click format>edit interactions,would you see the "highlight "icon:

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!