Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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?
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.
User | Count |
---|---|
123 | |
76 | |
62 | |
50 | |
49 |
User | Count |
---|---|
175 | |
125 | |
60 | |
60 | |
58 |