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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Billy597
Helper I
Helper I

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 @Billy597 ,

 

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 @Billy597 ,

 

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!




Please find the pbix file here. 

Hello @Billy597 ,

 

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!




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

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.