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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
Anonymous
Not applicable

Remove slicer interaction for second line of line graph only.

I have 2 filters and one slicer, and pie chart and the line graph in which i have issues with. Basically the line graph holds the count of patients over month and i want a second line for median and that should interact normally with the filters and pie chart but not the slicer. 
Filters are for states and pie chart is for segments, and slicer holds each individual accounts in slicer, so if i click any one account from slicer, I want to compares its count of patients (1st line) with the median of all patient count of all account in chosen state or segment.

Billy597_0-1706714620527.png



Second line would be a baseline for comparison. Your help would be appreciated.

Thanks!

1 ACCEPTED SOLUTION

Hello @Anonymous ,

 

check the attached pbix file.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

4 REPLIES 4
Idrissshatila
Super User
Super User

Hello @Anonymous ,

 

can you attach your pbix file so we could help you



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Anonymous
Not applicable

Please find the pbix file here. 

Hello @Anonymous ,

 

check the attached pbix file.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Anonymous
Not applicable

Thanks, this works. For anyone looking for solution, use this measure:

Median = CALCULATE(MEDIAN(NewPatient[NewPatientsCount]),REMOVEFILTERS('Account IDs'[Account Name]))

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 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.