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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Catching Correct Value Issue with Hovering Functionality in Line Chart

Hi Everyone,

 

I have an issue about showing values correctly on the line chart. X-axis includes date-time values and y-axis includes values.

When we move the mouse on values, it means that we are not hovering on the points, we are hovering on the line since we changed the colors of the lines as white.

 

We can see an example below not corresponds to 0 value but equals approximately to 1,024.

booblecap_0-1660044808515.png

 

The same issue is continuing even if we narrow down both date and values sliders as is seen from below screenshot.

booblecap_1-1660044832985.png

 

Even though the points seem there is only one value on it, there can be more than one values look like one point.

That's why when we are hovering the line (bc actually not the point),  we are selecting the wrong point.

booblecap_2-1660044858457.png

 

Finally, if we make a filter by creating a slider with ‘value’ column, we can see the correct values on chart as shown in below. However, I am looking for a better solution by not creating another visual to see correct value and points when hovering the mouse on them.

booblecap_3-1660044877934.png

 

As a note, I am using Azure Synapse connection on Power BI with DirectQuery to get live data from database. 

 

Is there any idea about how can it be fixed?

Many thanks in advance!

 

1 REPLY 1
HoangHugo
Solution Specialist
Solution Specialist

Hi

I think your X Axis has a lot of items (you define your time at unit of second), so when you hover, maye system will define wrong line.

Capture 3.PNG

try to edit Width in X Axis to create space that you can hover right line.

 

Any way, you narrow the Y axis scale, that mean it only show items belong to scale, but other items still be in chart but invisiable. Only you add new slicer, that is true filter.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors