Filtering by legend not highlighting the line on the current visual

[Anonymous]

Hi,

I have 2 'Line and Stacked Column Charts' showing 'Number of students' and 'Average hours' for all quarters of the year. The legend contains 5 things ( 4 quarters and the students/hours).

Without any filtering the charts look like below:

If I filter though the legend (suppose select Q4) in the first visual, it is highlighting the stacked columns in both the visuals correctly, but when it comes to the lines, it filters the line only in the second visual but not in the visual that I have the legend/filter in. 

Why this weird behaviour? It should behave like the following, and should highlight the lines in both the visuals.

How can I go about this issue?

I don't know many people in the forum but I'm tagging some of you for help: @marclelijveld , @Thejeswar , @V-pazhen-msft , @parry2k , @BeemsC 
But I appreciate any help! Thank you in advance!

Roopansh

https://www.linkedin.com/in/roopanshgupta1993/

[v-chenwuz-msft]

Hi @Anonymous ,

Cross-filtering removes data that doesn't apply.

Cross-highlighting retains all the original data points but dims the portion that does not apply to your selection.

For the line, its context is all the original data, so it will display the total of all.

For more details, you can refer this link.

Understand how visuals interact in a report - Power BI | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous when you click on a legend in the visual, it highlights the selected data point in that visual and cross highlights other visuals, so your line on the visual will not be selected, this is how cross filter/highlight works. Think about it, if you click on a data point in a bar, it will just highlight the selected part of the visual and the rest of the visual will be cross filtered/highlighted. I think it is working as expected. 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.