Forum Discussion

PaisleyMike's avatar
PaisleyMike
Regular Visitor
8 years ago
Solved

Values not affected by filter

Hello    I am looking for a way to show values but not have those values affected if a slicer is used    If this is possible help would be appreciated      Thank you   
  • MFelix's avatar
    MFelix
    8 years ago

    Hi PaisleyMike,

     

    The edit interaction is based on the full chart so the bar and lines will be or not affected by the slicers.

     

    To have waht you want you need to place in the lines a calculated measure with a ALL sintax as filter.

     

    As you can see below the red line is the measure i created in this case is:

     

    Measure = CALCULATE(SUM(Table1[Budget]);ALL(Table1[Project]))

     

    On the left you have a chart that don't have any interactions with the slicer in the right it as look at the red line and at the black line you will check that the red always stays the same:

     

     

     

    Regards.

    MFelix

alexei7's avatar
alexei7
Continued Contributor
8 years ago

Hi,

 

Yes you can do this.

 

If you select the slicer you should see a menu appear at the top with "Format" as the title.

If you click on this, there's an option to "Edit iteractions". Click on this and each visual will have a filter icon or a circle with a line through it. If you click the circle with line, that will mean that the visual will not be filtered by that slicer.