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

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.