Forum Discussion

ADP007's avatar
ADP007
Helper IV
5 years ago
Solved

Scatter chart - customize trend line

Hi all, is it possible with a scatter to do something similar to Excel?

The points are "AD Recall" vs "Familiarity"

The line is "AD Recall" vs "Market"

 

The idea is to have a trend line that is not the built in one of the visual it self.

 

Many thanks

ADP

 

Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi  ADP007 ,


    For your requirements, currently in powerbi, the visual provided by default does not meet your requirements for the time being. But it can be viewed and used in the powerbi store, which may not fully meet your needs. But you can use the default line visual, but the form of the line must be consistent, and then set the range of the two axes to achieve a similar visual. This may be the best way.

     

    If the problem is still not resolved, please provide detailed error information. Let me know immediately, looking forward to your reply.

     

    Best Regards,
    Henry

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

8 Replies

  • negi007's avatar
    negi007
    Community Champion
    5 years ago

    ADP007 in powerbi when you are using line chart visual, you have the option of adding various trend lines under the analytics tab.

     

    let me know if it helps you.

    • ADP007's avatar
      ADP007
      Helper IV
      5 years ago

      Hi negi007 thanks for you reply. I have seen that option but I want to use my calculated trend line. 

      I need to show a trend line based on other values. Comparing the values against the market values.

      Thanks

      ADP

  • negi007's avatar
    negi007
    Community Champion
    5 years ago

    ADP007 in that case, you may create a new measure that can be used in secondary axis to show the trend. I believe this is the way you can show your primary data as well as the customoized trend line

      • negi007's avatar
        negi007
        Community Champion
        5 years ago

        ADP007 yes you are right there is no secondary option. i got confused with the line chart. 

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    5 years ago

    Hi  ADP007 ,


    For your requirements, currently in powerbi, the visual provided by default does not meet your requirements for the time being. But it can be viewed and used in the powerbi store, which may not fully meet your needs. But you can use the default line visual, but the form of the line must be consistent, and then set the range of the two axes to achieve a similar visual. This may be the best way.

     

    If the problem is still not resolved, please provide detailed error information. Let me know immediately, looking forward to your reply.

     

    Best Regards,
    Henry

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

    • ADP007's avatar
      ADP007
      Helper IV
      5 years ago

      hi v-henryk-mstf 

      Thanks for your reply.

      I will accept this a solution even if it doesnt fill 100% my needs.

      In the meantim I have used the Python visual to achieve what I want.

      Thanks

      ADP

      • v-henryk-mstf's avatar
        v-henryk-mstf
        Community Support
        5 years ago

        Hi ADP007 ,


        Wow, this is good news, I am very happy that your problem can be solved.😀

        Best Regards,
        Henry