Static and dynamic chart in same visual

[ankitsuri26]

Hi, I am beginner in power bi and am creating a reporting dashboard for a becnhmarking data. I want to create a line chart visual and show 2 graphs. One graph gets dynmaically populated based on a selection. This i am able to do by using interactions. But the problem is that based on the selection in the slicer the other graph (which is supposed to be static benchmark) also changes. I am not able to figure this out. Can anyone help?

[ankitsuri26]

It worked like magic. thanks a ton!

[PijushRoy]

You are welcome @ankitsuri26 

[PijushRoy · Accepted solution]

Hi @ankitsuri26 

For static line please use REMOVEFILTER function which field you are using in slicer. Use the measure in X Axis
https://learn.microsoft.com/en-us/dax/removefilters-function-dax
Below is the example only

Total Profit (REMOVEFILTER) = CALCULATE(
    [Profit],
    REMOVEFILTERS(
        'Sales by Store'[Instance]
    )
)

 If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.

Thanks
Pijush