Forum Discussion
Highlighting Selected Data Point on Line Chart
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.
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
4 Replies
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.
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
Thank you so much!
That was the perfect solution to what I wanted to do 🙂
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!
