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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
wo_guy
Frequent Visitor

How do I overlay Log scale to Bar Chart?

I am trying to show a Log Scale line to a Bar Chart.

Capture.PNGCapture1.PNG

I created a line chart as you can find in the PBI file below but I am unable to overlay to the stacked column chart.

I have tried using the Line and Stacked Column chart but I dont have any option to show the line values as a Log Scale.

wo_guy_0-1611873667864.png

 

I tried writing DAX for the Log values but I guess I am very new to get the log DAX correct.

Please find the data linked below:

PowerBI File

Data Used

Can you please help?

Thanks

1 ACCEPTED SOLUTION
mahoneypat
Employee
Employee

Would it work to make a measure to calculate the Log value and use that on a linear scale

Log Net (Kg) = LOG(SUM('Cycle Reports'[NET [KG]]]))

 

mahoneypat_0-1611876609459.png

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

3 REPLIES 3
wo_guy
Frequent Visitor

@mahoneypat What would be the be the equation to show the trendline as an exponential trendline like the one you can see in excel?

wo_guy_0-1611880482779.png

 

The problem is that the log line is not a smoothed one (by design) and that would be the most desireable.

I don't think that will be easy.  The Analytics panel isn't active for that visual, so you'd have to calculate the equation terms with a complex DAX expression and then another measure to add the line to the chart.

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


mahoneypat
Employee
Employee

Would it work to make a measure to calculate the Log value and use that on a linear scale

Log Net (Kg) = LOG(SUM('Cycle Reports'[NET [KG]]]))

 

mahoneypat_0-1611876609459.png

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.