How to add a logarithmic trend line

[Anonymous]

I am trying to add a logarithmic trend line like the one available in Excel: 

I have seen that Power BI only has the option of linear trend lines. Could someone tell me how to do it? Thank you

[SawyerC]

This is not a solution, this is a work-around. Rarely do business users like to see logarithmic axis in my experience. Curved line is obviously more intuitive. Add a total option to ribbon charts too.

[negi007 · Accepted solution]

@Anonymous 

1. in this case you would need to change one of the axises to log instead of linear. You can change the axis as below

2. you can then add a trend line in the analytics tab. Your trendline will show data as per the axis type you have selected in the first step like log or linear.

I hope it resolve your issue. thanks