Allow User to Choose Average Line to Include into The Line Graph

[Deermeat]

Hello,

I'm trying to create a line graph that can have 2 types of line. First is individual issuer's line that I have already completed.

Second is to allow users to choose the average line that they want to include into the graph. This is done with a bunch of slicers that is provided. Ideally when the user click on the options in the slicers, the average line will be automatically included into the graph.

So if I click industry 1, industry 10, and rating 1, the 3 lines will appear on the graph with the name of the chosen item beside it.

Ideal Result:

Sample Data:

https://drive.google.com/file/d/1ASqkyyz4DlDltZDk_vjGw-8vcZ0KdrKq/view?usp=sharing

Thank you!

[Deermeat · Accepted solution]

I gave up on trying to get it into the same graph and just overlay another graph ontop of it with the background set to transparent. 

[amitchandak]

@Deermeat , Create an average measure using these values

example

calculate(Average(Table[Value]), Allselected)

In the analytics pane, Use Y-axis Constant line, Then under the line option use fx and use this new measure

[Deermeat]

@amitchandak,

Hi I tried your method by using this measure:

Average = CALCULATE(AVERAGE(Data1[IssuerScore]), ALLSELECTED())

However, the average line that result from it is a constant line that doesnt not change no matter what is being chosen or even not chosen in the slicer. Also, it seems unable to take 2 choices from the slicer and generate 2 different lines. 

Do you have any idea how to fix this?

Sample File: https://drive.google.com/file/d/1ASqkyyz4DlDltZDk_vjGw-8vcZ0KdrKq/view?usp=sharing

Thank you