Forum Discussion
Trend Line in Power BI
Just in case, I came across this thread which talks about creating trendlines with DAX. You could try writing your own measure and then decide whether you want to use the combined bar and line chart or the DIY method.
Regards,Paul.
I simple created a Line Chart in a separate visual, made the backround transparent, moved the Y Axis to the right, turned off the x axis and then overlayed it over the stacked bar visual. (in the image I posted, you can see both individual visuals (Line Chart and stacked chart on the top centre and right. The final visual on the top left is the Stacked chart with the Line chart on top of it, adjusting the size of the frame so that the individual markers of the Line chart match the bars of the Stacked Chart underneath.
For illustration purposes of what I am trying to explain, here are both visuals. I've added a greyish backround to the Line chart so you can see the actual visual lying on top of the Stacked Chart. (You obviously need to set this Line Chart backround to transparent by truning off the backround in the Line Chart visual in the actual report page.
Also make sure you bring the Line Chart visual to the front
I understand that. But what does your line chart shows in this case.
It's just a sales trend line. It's a dummy model I use to test measures and try out stuff. the stacked chart are sales; the trend line chart are sales.
The data itself is irrelevant; I was just trying to help you by offering a DIY solution. Not perfect by any stretch of the imagination, but doable.
Edit: just out of curiosity, what trend line are you trying to include?
I want to show trend line based on the ticket count weekly. As shown in my initial question.