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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi,

 

For the measure on the global sales visual, jsut make a new measure and remove filters on employee

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