Forum Discussion

IZJT76's avatar
IZJT76
New Member
4 years ago

Exclude specific value from being filtered via Slicer

I have a dataset of audit scores for our offices - our audits consist of 18 seperate 'sections' with each section getting a score between 0-4.  The visual below shows the offices' value for each audit section (bars) being overlaid with the average of that value (line) so we have an average company benchmark in each section.

What I'd like to do is stop the Company Average line changing when I use a slicer to select different offices - so the bars move up/down as we slice between offices but the line stay constant, so we can compare each office's performance against overall company average.

Is there an easy way to do this??

 

 

Need Help

8 Replies

  • littlemojopuppy's avatar
    littlemojopuppy
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi IZJT76 

     

    You have a measure for the line (I assume).  If so, modify it like this (and if you don't make one like this)

     

    CALCULATE(
    [Existing Line Measure],
    REMOVEFILTERS(Tabl;e[Office])
)

     

    Not syntactically perfect because I don't know the measure name or the table/field for office.  But if you follow that pattern, you should get what you're looking for.

     

    Hope this helps!  ðŸ™‚

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    Something like this

    Measure = calculate([Measure],all(data[Offices]))