Forum Discussion

ankitsuri26's avatar
ankitsuri26
Regular Visitor
2 years ago
Solved

Static and dynamic chart in same visual

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?

 

 

Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    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

3 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    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