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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.