Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

ALL slicer selection

I need to see the latest data when the period selection is all across the file , at the same time it should not have a direct filter for latest period as it should also work based on the other period selection.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  Anonymous ,

     

    Not sure what you mean, do you mean you have many slicers and you want only one of them to work on a Visual, and when this slicer is filtered, then Visual shows the latest data for this slicer interval, and if there is no filter, then Visual itself shows the latest data

    You can choose Editinteractions -- select the Slicer you don't want to affect -- Edit interactions -- click on the yellow tab of the Visual you don't want to be affected.

    This way, the selection of the Slicer will not affect the Visual

    Refer to:

    Change how visuals interact in a report - Power BI | Microsoft Learn

    If it doesn't suit you, you can present the results you want in the form of a picture and we can help you better.

     

    Best Regards,

    Liu Yang

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