Forum Discussion
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 average price, without being influenced by the type of store.
Is this possible?
Thank you in advance for your help!
sara_pinto15
Under Reference Line, Add a X- Axis or Y-Axis line, you will have a fx button to prvide your custom formual
3 Replies
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
