Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
IEG_CSC12
Frequent Visitor

trend line logarithmic

I am trying to add a logarithmic trend line like the one available in excel, but this option is not available in power bi. I tried to plot it using the line graph, using the previously calculated data in excel, but unfortunately, as I must calculate it based on many filters, it's not possible to calculate the data in excel for all the options that can be selected

 

When I tried to calculate using Dax function in power bi, the report got too slow, because I must calculate for 35 different variables, so the code is long and has a lot of variables.

 

Is there a way for calculate the logarithmic trend line without using Dax, or if using Dax in an optimized way?

2 REPLIES 2
riegersn
Helper I
Helper I

This does not work. As you can see below, the pink trend line is most certainly linear while the y-axis is set to logarithmic. 

 

riegersn_2-1665782801900.png

 

While this same data plotted in excel with a logarithmic trend looks like this...

 

riegersn_3-1665782852762.png

 

You can see how the trend should look here.

 

 

JorgePinho
Solution Sage
Solution Sage

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.