Forum Discussion
sara_pinto15
Helper I
Helper IAverage 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
Fowmy
Super User
Super Usersara_pinto15
Create this measure and add it as a reference line:
Overall Average Price =
CALCULATE ( AVERAGE ( 'pricestable'[Price] ), ALL ( 'pricestable'[StoreType] ) )
sara_pinto15Helper I
Helper IIs it possible to create a custom reference line? I only see the following options that calculate automatically and result in constant lines.
- Fowmy
sara_pinto15
Under Reference Line, Add a X- Axis or Y-Axis line, you will have a fx button to prvide your custom formual