Filtering by slicer. Is it possible to keep an overall mean line in the line plot?

[Marit]

Hi!

I'm making a line plot where I can choose different categories by a slicer. Is it possible to keep an overall mean line the plot when a choose a specific category to compare with the total?

Regards Marit

[Mariusz]

Hi @Marit 

You can add an extra Measure like 

Measure = 
CALCULATE(
    AVERAGE( 'Table'[Column1] ),
    ALL()
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Marit · Accepted solution]

Thank you for your answear. I am not sure if I explained my self enough. I have noticed that when I have bar plot and choose one category, the result within that category is shown with a darker coloured bar, and the overall result for all categories is shown with ligther color at the same bar. Is this possible with a line plot as well? For example with a dashed line for the overall result for all categories, and solid line for the result within selected category?

Furthermore, I have one page with synchronised slicers. Must the slicer be at the same page to show both overall result and within category result? I seems like that with the bar plots.

Best regards

Marit

[v-juanli-msft]

Hi @Marit 

Create a measure

all cate = CALCULATE(AVERAGE('Table'[value]),ALL('Table'[category]))

the slicers on the Page1 can only affect visuals on Page1.

If you want a filter to affeact all pages, please add the column into "Report level filters".

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.