Forum Discussion

RG_HC's avatar
RG_HC
Frequent Visitor
8 years ago
Solved

Exclude second plotted line from filter on line chart

Hi all   I have some data averages that I have plotted on six separate line charts, with a custom filter that filters the result by Customer (there are 35 customers).   I'd like to add a second l...
  • MFelix's avatar
    MFelix
    8 years ago

    Hi RG_HC,

     

    You can do that on the query editor making the addtional line and adding it to your model as a single row, however you would need to filter that line out from other visuals / reports or else your results would always be impacted by that.

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi RG_HC,

 

Not really sure how you are getting the information you need if trough measure o calculation in visual, but you can do the following.

 

  • Create two or more measure to use in your charts ( the only way to add additional lines in the line charts is to have measure and nothing on legend)
  • My measure are as follow:
  • Average_Blue = CALCULATE(AVERAGE(Data[Value]); Data[Color] = "Blue")

Average_Total = CALCULATE(AVERAGE(Data[Value]);ALL(Data[Color]))
    the first one I repeat per colour, but again this is just a mockup data not sure how yours is setup and the second one is the important one because adding the filter in the CALCULATE with ALL it ignores the filters you have on your measure and calculates to the overall data so the final result is below

 

 

As you can see the black line that refers to Total Average is always the same so having comparision with the different colours.

 

Regards,

MFelix