Forum Discussion
Creating an Average Line/tooltip within a line chart
Would think this would be pretty easy but I'm having problems. I have a Line Chart made setup with Date/Month as the Axis, Year as the legend, and my values are made up of a ton of individual values that I total. Currently the data is showing 2014-2019 and my hope is to show either an average line or show that average of all those data points for a given month in the tooltip. When I try the Average Line within analytics, it just shows a straight line so no good there. One issue I want to add is the data within the line chart I slice by categories so I would need the average line to be able to move based on how I slice.
Any ideas?
HI cjdillon ,
AFAIK, current power bi does not support to use the legend and multiple values at same time. (power bi no support analyst multiple link graph at same time)
You can remove the legend and write a measure to calculate specific values or create a custom report tooltip page with visuals to display them.
Create tooltips based on report pages in Power BI Desktop
Regards,Xiaoxin Sheng
1 Reply
HI cjdillon ,
AFAIK, current power bi does not support to use the legend and multiple values at same time. (power bi no support analyst multiple link graph at same time)
You can remove the legend and write a measure to calculate specific values or create a custom report tooltip page with visuals to display them.
Create tooltips based on report pages in Power BI Desktop
Regards,Xiaoxin Sheng