Need tooltip to show a time development for scatter plot.

[FabianB]

Hi,

does anyone know a way to show a time development as a tooltip for a scatter plot?

I want to plot my data in a scatter plot for a given timepoint. If the user hovers over a datapoint of this scatter plot I want to show the development of the data over time.

I attached two pictures for a better explanation. So my scatter plot shows single data points for a single time point.

I managed to configure the tooltip which is shown below the scatter plot.

However, when I enable filters to propagate to the tooltip it will only show the data for a single time point. When I disable filters for the tooltip it will show me a development over time. But it will show the same (average) development for all data points of the scatter plot instead of only the values over time for 1 single data point. I also managed to show the data over time averaged by the machine type category in the tooltip but I cannot manage to really show the single machines. Does anyone how to configure this?

Thank you very much!

Best

Fabian

[Anonymous]

Hi @FabianB ,

 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: Scatter, bubble, and dot plot charts in Power BI - Power BI | Microsoft Learn

I have also found a similar post, please refer to it to see if it helps you.

Solved: Scatterplot over time - Microsoft Power BI Community

Best Regards
Community Support Team _ Polly

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

[FabianB]

Hi @Anonymous,

thank you so much for your friendly reply!

You wrote: "Add a field to the Details well to tell Power BI how to group the values."

Unfortunately in Power BI Desktop I cannot find a Details well for my scatter chart. Is this one available in the Power BI Service only?

Thanks again for helping!

Best

Fabian

[Anonymous]

Hi @FabianB ,

As far as I know, the new version of the scatter chart does change a bit, but this feature has not been abandoned, Depending on the data , might worth creating an index column.

• Details: to specify what categorical column the visual represents
• Legend: to specify which column sub-divides the Details data
• X-Axis: specify what column represents the horizontal axis
• Y-Axis: specify what column represents the vertical axis
• Size: specify the column that represents the marker sizes
• Play-Axis: specify what column (usually a date column) is responsible for the trend overtime.
• Tool Tips: add a data field or measure to be included in information displayed when hovering on a mark in the chart.
  

Solved: Scatter chart - Microsoft Power BI Community

Best Regards
Community Support Team _ Polly

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

[FabianB]

Hi @Anonymous,

Thanks again for your help.

Strange thing is that still even after adding index columns to my tables I do not get a "Details" well for my scatter chart. 

The wells I get are "Values", "X Axis", "Y Axis", "Legend", "Size", "Play Axis" and "Tooltips".

Could this be caused by you using a different version of Power BI than I use?

I am using Version: 2.112.603.0 64-bit (December 2022).

Is this the same one you are using?