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 se...
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

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