Looking to get filter to only affect one line chart

[gbarr12345]

Hi there,

I have a report where I need 2 line charts side by side.

I have a filter on the first line chart which works ok. However I'm creating the second line chart and when I put a filter on that too it affects both graphs. 

Is there a way to make a filter only affect one graph and not make it change the data on the other graph?

[amitchandak · Accepted solution]

@gbarr12345 , if there are two graphs, then you can use interactions.

How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4

If only one graph has two lines.

then in one of the graphs you use a measure that ignores the file

calculate([Your measure], removefilters(Table[Category]))

or have slicer on a disconnected/independent table and let only one measure use it

filtered measure

calculate([Measure], filter(Table, Table[Category] in category[Category]) )

Need of an Independent/disconnected Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE

Need of an Independent/disconnected Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

Power BI How to use/compare two Date/Period slicers: https://youtu.be/WSeZr_-MiTg

[gbarr12345]

That's great, thank you very much for your help Amit!