cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ADP007
Helper III
Helper III

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

 

2021-04-15_14-54-45.png

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

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.

v-henryk-mstf_0-1618995248211.pngv-henryk-mstf_1-1618995521632.png

v-henryk-mstf_2-1618995540529.png

v-henryk-mstf_3-1618995559084.pngv-henryk-mstf_4-1618995585422.png

 

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.

View solution in original post

8 REPLIES 8
v-henryk-mstf
Community Support
Community Support

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.

v-henryk-mstf_0-1618995248211.pngv-henryk-mstf_1-1618995521632.png

v-henryk-mstf_2-1618995540529.png

v-henryk-mstf_3-1618995559084.pngv-henryk-mstf_4-1618995585422.png

 

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.

View solution in original post

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

Hi @ADP007 ,


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

Best Regards,
Henry

negi007
Super User II
Super User II

@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




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos


Proud to be a Super User!

Follow me here


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

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




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos


Proud to be a Super User!

Follow me here


negi007
Super User II
Super User II

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

 

negi007_0-1618494312658.png

let me know if it helps you.




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos


Proud to be a Super User!

Follow me here


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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors