Highlighting Selected Data Point on Line Chart

[annaharris]

Hi Everyone,

I'm trying to create a line chart which displays a specific point over the chart depending on what is selected. 

There are three slicers at the top which impact the line chart as well as the data in the left table (shown with the red arrows), the slicer at the bottom impacts the right hand table. The three slicers at the top will show multiple pieces of data while the one at the bottom is making an individual selection.

I want a line to appear on the chart or an indicaiton on the chart showing the "individual selection" from the bottom slicer, I've drawn a pink rectangle for an example of how I'd like it visualised.

Any help figuring this out would be greatly appreciated.

[Uzi2019]

Hi @annaharris 

Check this video for better uderstanding

https://www.youtube.com/watch?v=FnEKyhSf2mM

https://www.youtube.com/watch?v=8RzZppthNPk

https://www.youtube.com/watch?v=6sHQZrrGbvo

I hope above videos would help you to solve your query.

I hope I answered your question!

[danextian · Accepted solution]

Hi @annaharris 

Using the slicers as is will not highlight the selected points but will filter the view to just what is selected. If you want to show both the selected and not, you can use a disconnected table to highlight points in the line chart and another measure that shows what just what is highlighted. Please see attached sample pbix

[annaharris]

Thank you so much!

That was the perfect solution to what I wanted to do 🙂

[Ritaf1983]

Hi @annaharris 

Unfortunately, what you are trying to achieve isn’t possible with the current setup. The bottom slicer does not affect what is displayed on the X-axis of the line chart . This means that there is no direct way to tell the line chart engine to highlight or select a specific part of the data at a certain date, as desired.

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