Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Balance Sheet Filtering

Hi,  I am trying to create a Balance Sheet Report in Power BI, & i am struggling to work out how to create dynamic comparison periods.    The way the datamodel is built & because the balance s...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    For the problem "the slicers are changing both measures rather than just the one for each slicer", I can offer you a solution:
    As the screenshot shows, I created two slicers and two table visual objects. I first select the slicer on the left, click on "Format", click on "Edit interactions", and then disable filtering on the right side of the form and slicer, and don't do anything on the left side of the form.



    Then select the right side of the slicer, the same steps will be the left side of the table and the slicer to disable the filter, the right side of the table do not do any operation.

    Then you can realize the effect of a slicer acting on a visual object.

     

    Best Regards,

    Dino Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.