Forum Discussion

julsr's avatar
julsr
Icon for Continued Contributor rankContinued Contributor
1 year ago
Solved

Scatterplot with trendline no available

Hello! I have a scatter plot like the one below. However, what I need now is to have a trendline for each of my legend values. I previously saw this option in the analytics tab, but I can't ...
Need Help
Show and Tell
Tips and Tricks
  • burakkaragoz's avatar
    burakkaragoz
    1 year ago

    To add a trendline for each legend value in a Power BI scatter plot:

    1. Add the desired field to the Legend section of the scatter plot.
    2. Select the scatter plot and open the Analytics pane.
    3. If the Trend Line option is missing:
      • Ensure you're using the built-in scatter plot visual, not a custom one.
      • Confirm that both X-Axis and Y-Axis fields are numeric.
      • Power BI supports one trendline per series, so the legend must split the data into multiple series.
    4. If the option still doesn't appear, update Power BI Desktop to the latest version.

    Note: Using a Date Hierarchy on the X-axis may cause issues with trendlines, especially when multiple months are selected, due to overlapping day values.
    translation and formatting supported by AI

burakkaragoz's avatar
burakkaragoz
Icon for Super User rankSuper User
1 year ago

Hi julsr ,

 

To add a trendline for each legend value in a scatter plot in Power BI:

  1. Ensure the legend field is added to the "Legend" section of the scatter plot.
  2. Go to the Analytics pane (select the scatter plot first).
  3. If the Trend Line option is missing:
    • Make sure you're using the built-in scatter plot visual, not a custom one.
    • Check that "X-Axis" and "Y-Axis" fields are numeric.
    • Power BI only supports one trendline per series, so the legend must split the data into multiple series.

If the option still doesn't appear, try updating Power BI Desktop to the latest version, as this feature may have been temporarily removed or changed.
translation and formatting supported by AI

  • julsr's avatar
    julsr
    Icon for Continued Contributor rankContinued Contributor
    1 year ago

    Thank you both v-venuppu ! The problem is that my X-axis is a Date Hierarchy. It works with one month as the days are not repeated, but when trying with multiple months, the values are incorrect (For example, if viewing from Jan 01 to Feb 01, the values for the first day appear at a single point on the x-axis.). Is it a limitation of the Power BI Scatter plot?

    • burakkaragoz's avatar
      burakkaragoz
      Icon for Super User rankSuper User
      1 year ago

      To add a trendline for each legend value in a Power BI scatter plot:

      1. Add the desired field to the Legend section of the scatter plot.
      2. Select the scatter plot and open the Analytics pane.
      3. If the Trend Line option is missing:
        • Ensure you're using the built-in scatter plot visual, not a custom one.
        • Confirm that both X-Axis and Y-Axis fields are numeric.
        • Power BI supports one trendline per series, so the legend must split the data into multiple series.
      4. If the option still doesn't appear, update Power BI Desktop to the latest version.

      Note: Using a Date Hierarchy on the X-axis may cause issues with trendlines, especially when multiple months are selected, due to overlapping day values.
      translation and formatting supported by AI

      • julsr's avatar
        julsr
        Icon for Continued Contributor rankContinued Contributor
        1 year ago

        Thanks. This worked for the trendline, I'll open another post for the issue with multiple months.