Forum Discussion

azaterol's avatar
azaterol
Helper V
4 years ago
Solved

Ignore filter

Hello everybody,   I have a problem with my visuals.  If I use the slicer and choose beetween the employees, the total sales changes to the sales how much the employee is made total.  Also the sa...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, azaterol 

    If you just want to keep the chart unaffected by the slicer, change the interaction behavior between the slicer and the visual.

    Change the interaction behavior 

    If you only want the values in some columns not affected by the slicer, such as the sales from 2022, please add a new formula as below.

    New Sales 2022=Calculate([Sales 2022],ALL('Table'[Employees]))

     

    Best Regards,
    Community Support Team _ Eason

azaterol's avatar
azaterol
Helper V
4 years ago

Hey Anonymous , 

sorry I didn't understand that. Could you please explain clearly?

Thank you 

v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

Hi, azaterol 

If you just want to keep the chart unaffected by the slicer, change the interaction behavior between the slicer and the visual.

Change the interaction behavior 

If you only want the values in some columns not affected by the slicer, such as the sales from 2022, please add a new formula as below.

New Sales 2022=Calculate([Sales 2022],ALL('Table'[Employees]))

 

Best Regards,
Community Support Team _ Eason