Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
shaebert
Helper III
Helper III

Need help visualizing data

Hello, I have a set of data that I want to visualize in a line graph showing changes over time. I am having some difficulty in using the graph in combination with two table visualizations. 

 

Data Set: 

CompanyScoreDateTopic
Company3703/20/21Cyber
Company3803/20/21IT
Company1453/20/21Data
Company2653/27/21Cyber
Company2803/27/21IT
Company2753/27/21Data
Company1663/27/21Cyber
Company1553/27/21IT
Company1804/3/21Cyber
Company1904/3/21IT
Company1904/3/21Data


I want to be able to click a company in the table on the bottom left. With that company selected, I want to be able to click on the Orange line in the graph to supply me the "IT" topic on the table on the right. Right now when I do this, I am selecting either the March 27th data point or April 3rd data point. I want both selected where ever I click on the line. Is this possible?

 

Screen Shot 2021-04-08 at 1.56.49 PM.png

 

I noticed that if I hold down Control and select each data point this works, but this is neither intuitive for others, nor do I want to do this if I have a lot of data points. 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @shaebert ,

 

After my testing and related research, it is useful to hold down ctrl to select multiple.

Screenshot 2021-04-14 165356.jpg

Also, you can create two slicers to filter instead of clicking on the line chart.

Screenshot 2021-04-14 165235.jpg

 

 

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

View solution in original post

3 REPLIES 3
shaebert
Helper III
Helper III

Unfortunately, holding down CTRL and selecting multiple points is not intuitive for the users/viewers of the dashboard. I think I am just going to have to not use a line graph visual. 

Anonymous
Not applicable

Hi @shaebert ,

 

After my testing and related research, it is useful to hold down ctrl to select multiple.

Screenshot 2021-04-14 165356.jpg

Also, you can create two slicers to filter instead of clicking on the line chart.

Screenshot 2021-04-14 165235.jpg

 

 

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

Jihwan_Kim
Super User
Super User

Hi, @shaebert 

One of the ways to select multiple data points in a line chart is to CTRL + Drag the mouse.

However, seeing the above screen, I think it might capture unwanted datapoint as well if you drag the mouse in the line chart.

But, it is useful in many cases.

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.