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

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

Hi,

 

Write a measure like this

 

=CALCULATE([your measure],ALL(Data[Customer]))

 

Hope this helps.

RG_HC's avatar
RG_HC
Frequent Visitor
8 years ago

Thanks all; all work in their way however the issue is that I have 35 lines on the line chart that I use the filter visualisation for. So the customer can click any one or several customer IDs to see selected customer lines on the chart. In order to show the default of all, I need to have the Legend active, which removes the ability to add a second item under value, which is what I'd need to get this to work. 

 

The only way I see this working (to my way of thinking) is if there was someway to create a custom ROW that had these averages for each category, which could be included in the filter as a selectable option. Has anyone heard of doing this before?

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    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