Average on a graph unaffected by day

[Anonymous]

Spoiler

Hi all,
I have created an average measure in Power BI and then using this measure have created two more measures that are 20% above and 20% below this average. This is visible in the table above the bar chart and also changes based on the day of the week selected as well as the quarter selected on the slicers below the bar chart (as shown by the first 2 screenshots).
Currently however, when i add this measure to the bar chart the average changes day by day (as shown in the 3rd screenshot). I do not want this and i want it to be able to stay the same as it is shown in the table above the bar chart but instead as a solid line all the way along the bar chart. And I only want this average to change when selecting the 2 slicers that are on the page but still remain as a solid line across the bars.

Essentially how do i get the average line highlighted in the 4th screenshot as a measure and also 2 more lines that do the same thing for 20% and 20% below that average.

Please could you advise on whether this would be possible and how i would go about doing this if so. 

Thanks


Screenshot 1Screenshot 2Screenshot 3Screenshot 4
 

[Greg_Deckler]

@Anonymous What do your measures look like? Generally you can use something along these lines:

Measure Average = AVERAGEX( ALL('Table'), [Value] )

[Anonymous]

@Greg_Deckler, My measures look like this

[Greg_Deckler]

@Anonymous Try:

AverageFootFall = AVERAGEX( ALL('Priority Zone'), [total visitors] )

Your other measures can remain the same.

[Anonymous]

@Greg_Decklerthe only issue is when i do that, the average stays the same regardless of what i select on the slicers. So it is not dynamic as I wish it to be. The graph also becomes quite gapped. 

[Greg_Deckler]

@Anonymous Use ALLSELECTED then instead of ALL. So like:

AverageFootFall = AVERAGEX( ALLSELECTED('Priority Zone'), [total visitors] )

[Anonymous]

@Greg_DecklerThanks that has worked, the only thing now is the graph still looks like this.I dont suppose you know how i would go about making it so there was no gaps between the bars when only selecting one day?

Thanks for your help.

[Greg_Deckler]

@Anonymous Ah, well, you could try changing the x-axis to categorical instead of continuous.

[Anonymous · Accepted solution]

@Greg_Deckler I have just used the filter to only show total visitors when the value is "not blank" and that has fixed it for me.

Thank you for your help with everything though!

[Greg_Deckler]

@Anonymous That's a great solution!