Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
A-R
Frequent Visitor

Setting up slicer to affect only selected series on the chart

Hi,

 

I have created a chart, where I have presented long term normal distribution of daily production. Now I would like to present in the same chart daily production for selected period to visualise how we have succeeded compared to the history. My problem is that, when I adjust slicer, it will also change the normal distribution. Is there any way to "freeze" the normal distribution / bell curve?

 

Normal distribution and daily production YTD (=all data)

 

AR_0-1722502681214.png

When I change the dates on the slicer also the normal distribution changes even thoug I want it to stay same as in the firs pitcture.

 

AR_1-1722502805401.png

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @A-R ,

 

I see what you mean. There doesn't seem to be a function for this, but what I can think of is the ability to split this visual object into two visual objects stacked on top of each other and adjust the transparency of the normal distribution line graph.

vtianyichmsft_0-1722576410760.png

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi @A-R ,

 

Select this slicer and then open the tab Format=>Edit interactions to turn off interactions for this visual object.

vtianyichmsft_1-1722564215992.png

Change how visuals interact in a report - Power BI | Microsoft Learn

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

A-R
Frequent Visitor

Hi, @Anonymous 

 

It seems that interactions are not solution in my problem, since both series are in the same chart (line is the normal distribution and bars is the production). It would be great though, if I could turn off interactions to one series of the chart.  

Anonymous
Not applicable

Hi @A-R ,

 

I see what you mean. There doesn't seem to be a function for this, but what I can think of is the ability to split this visual object into two visual objects stacked on top of each other and adjust the transparency of the normal distribution line graph.

vtianyichmsft_0-1722576410760.png

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

A-R
Frequent Visitor

Thank you @Anonymous! This was the solution. 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors