Forum Discussion

FabianB's avatar
FabianB
Frequent Visitor
3 years ago

Need tooltip to show a time development for scatter plot.

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...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
    FabianB
    Frequent Visitor
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        FabianB
        Frequent Visitor
        3 years ago

        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?