Scatter chart - customize trend line

[ADP007]

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

[v-henryk-mstf · Accepted solution]

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]

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]

Hi @ADP007 ,

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

Best Regards,
Henry

[negi007]

@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

[ADP007]

Hi @negi007 there is no secondary axis as far as I can see.

[negi007]

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

[negi007]

@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]

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