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! Learn more

Reply
jlee724
Frequent Visitor

Preventing a slicer from impacting a specific line in a line graph

I have this graph, with 4 lines. And a slicer that allows you to choose an individual. I want to a line constant where it stays showing the grand average line. This way, when you select a name, you will be able to see their averages compared to others over time. Screenshot 2023-07-27 141513.pngScreenshot 2023-07-27 141333.png

2 REPLIES 2
amitchandak
Super User
Super User

@jlee724 , You create a measure ignoring the filter using all or removefilters and you can use that as constant line in analytics/visual pane

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandakMy issue with a constant line is that I need the line to show variance of day to day or month to month, etc. However, the constant line is a flat average of the total data. I want to see the remove filters line like above. The remove filter line should be the exact same line as above, but when I change the Dispatcher slicer to someone, it should stay that line while the other line changes. 

Helpful resources

Announcements
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!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

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