Scatter Chart showing only tooltips for the first x axis value

[Anonymous]

Hi all,

The Scatter Chart is only showing tooltips on hover for the first X Axis Value, which is a Date in this case. All the other data points to the right are without tooltips. I checked with different slicers and filters, i changed the data set i even created a completely new chart, but none of this helped.

EDIT:

So the issue here is the "Legend" field in Scatter Plot. If I delete the Legend, the tooltips work fine. Any Idea why the Legend would affect the tooltips?

[Greg_Deckler]

@Anonymous - I cannot replicate this behavior, what version of the Desktop are you in? I am using August 2020

[Anonymous]

Hi! I am using the latest version of pro

[FarhanAhmed]

It seems that your Legends fields is making your Tooltip fields/measure as Blank, therefore you are not able to view those on tooltip.

[Anonymous]

Right, but why?
Some columns i put into Legend are fine, but some aren't and cause this issue.

[FarhanAhmed]

What is your legend field ?

Is it coming from some other table ? try check joins or calculation of measure.

If possible share some sample data

[Anonymous]

All fields come from the same table. There are no measures. There are no blank fields in the columns I'm using in the Legend. Some seem to work fine and some of them will only show tooltips for the left half of the scatter chart. I think it's a bug.

How do I share a sample ?

[FarhanAhmed]

---

@Anonymous wrote:

All fields come from the same table. There are no measures. There are no blank fields in the columns I'm using in the Legend. Some seem to work fine and some of them will only show tooltips for the left half of the scatter chart. I think it's a bug.

How do I share a sample ?

---

The First Function returns the First Value of given set. so if your data combination contains blank or null values it will return blank or null. change the aggregation to MAX or use the CONCATENATEX function to create measure of your text fields and then use them as tooltip

[Anonymous]

There are no null values, there is no data missing. I can't use MAX for text values. And all of the fields I put into TOOLTIPS are text. The goal here is that I want a Scatter Chart, which has a ticket duration on the Y AXIS and Dates on X AXIS . Each of the data points is supposed to represent a single incident raised with a reference number. Trouble is that when i use the reference number as DETAILS and Date as X AXIS i get this:

When I remove the details I get this (X Axis Dates not in order and tooltips showing for the left 3/4 of the chart, but not all of it)

What am I doing wrong ?

[FarhanAhmed]

A scatter chart always has two value axes to show: one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis. The chart displays points at the intersection of an x and y numerical value, combining these values into single data points. Power BI may distribute these data points evenly or unevenly across the horizontal axis. It depends on the data the chart represents.

Add a field to the Details well to tell Power BI how to group the values. The field must be unique for each point you want to plot. A simple row number or ID field will do.

Ref: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter

Since your X Axis already contains a data-point, and creating a details will create multiple combination of data points causing error "Remove Details to display x- and y-axis pairs. Alternatively, you can keep Details and set a summarization for x- and y-axis."

[amitchandak]

@Anonymous , I am able to see both axis value when both are measures.