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.
Not sure if it will work for you, but you could try creating a seperate trend line visual and stack it on top of the original, with the formatting adjustments to ensure it is clear. I tried this out:
The main setback for this solution is that the tooltips in the stacked chart won't be accesible since the visual lies behind the trend line visual, though you could include a complemetary Pie Chart to show the values selected. (And Focus mode will only bring up the selected visual of course).
Edit: IF you do go down this route, make sure to play around with the "Edit Interactions" to ensure that the overlying trend line doesn't become confusing. For example, in the example with the Pie Chart, to make sure the markers line up with the corresponding month, I activated the option "Show Items with no data" in the month field of the trend line chart. By this, if I select a portion within the pie chart to filter the other visuals, the markers remain aligned with their corresponding months.
Basically it needs tweaking a bit, but is doable.
