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

quentin_vigne's avatar
quentin_vigne
Solution Sage
8 years ago

Hi PaisleyMike

 

You have to got to Format > Edit interactions 

 

And you have to click else on the filter icon or the other one

 

 

Quentin

  • PaisleyMike's avatar
    PaisleyMike
    Regular Visitor
    8 years ago

    Thanks 

     

    Also is there a way to do this withing a line and stacked Chart 

     

    e.g 

     

    Bar chart is able to change 

    Line chart remains unchanged 

    • quentin_vigne's avatar
      quentin_vigne
      Solution Sage
      8 years ago

      PaisleyMike

       

      yes you can do that, there is the same option, you only have to click on the the slicer and then choose the filter on the line chart

      • PaisleyMike's avatar
        PaisleyMike
        Regular Visitor
        8 years ago

        Unfortunetly cant get it working 

         

         

        I can get it working with seperate chart but cannot get it working for this type of chart 

        which is a Line and clustered column chart 

  • JonatanM's avatar
    JonatanM
    Frequent Visitor
    3 years ago

    Dear Quentin,

     

    Thanks for this reply, I get it to work. But I would like a visual to be unaffected by ALL slicers. I currently have plenty in my report, and setting this up for each and every one of them is a bit tedious and I think poor practice... Any ideas? Thanks a lot!

     

    Jonatan

    • MFelix's avatar
      MFelix
      Super User
      3 years ago

      Hi JonatanM 

       

      If you have a specific visual that you don't want to be affected by the slicer then you need to create a measure or measure specifically designed for that visual that will keep filters untouched.

       

      Depending on what is the calculation you are doing this can be done using a REMOVEFILTERS for example:

       

      https://dax.guide/removefilters/

       

      There are other alternatives but please check the documentation and if needed get back to me please.

      • JonatanM's avatar
        JonatanM
        Frequent Visitor
        3 years ago

        Thanks Miguel, I have been unable to try this out as of yet but it looks very much like what I was looking for.