Forum Discussion

Deermeat's avatar
Deermeat
Resolver I
4 years ago
Solved

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

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 the...
Need Help
Tutorial Requests
  • Deermeat's avatar
    Deermeat
    4 years ago

    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's avatar
amitchandak
Super User
4 years ago

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's avatar
Deermeat
Resolver I
4 years ago

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