Forum Discussion
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
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.
While this same data plotted in excel with a logarithmic trend looks like this...
You can see how the trend should look here.
