Forum Discussion
Solved
Average per month line
Hello everyone, I am working on a report in Power BI where I have a line chart showing the evolution of prices by type store. I would like to add an additional line that represents the overall avera...
sara_pinto15
Under Reference Line, Add a X- Axis or Y-Axis line, you will have a fx button to prvide your custom formual
sara_pinto15
Create this measure and add it as a reference line:
Overall Average Price =
CALCULATE ( AVERAGE ( 'pricestable'[Price] ), ALL ( 'pricestable'[StoreType] ) )
Is it possible to create a custom reference line? I only see the following options that calculate automatically and result in constant lines.
sara_pinto15
Under Reference Line, Add a X- Axis or Y-Axis line, you will have a fx button to prvide your custom formual