Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Visual filter hands over filter to another visual when crossfiltering

Hi to everyone,

I have two visuals. One is filtered to 2015 (right visual) and one to 2014 (left visual) on visual filter level:

 
 

 

If you click on a product of one of theses visuals, in this example the right one, to crossfilter other visuals, the other visual will be completely blank, because the filter year = 2015 is handed over to the other visual which is filterted to year = 2014.

 

 

Is this a standard behaviour or is this a bug? Is this somehow configurable?

 

Cheers

Need Help
  • tex628's avatar
    tex628
    6 years ago

    It's normal behaviour. When selecting it will take all the filters that are applied to the element and apply them to the other objects.

    I think you should be able to work around it with something along the lines of this: 

    Sales Amount 2014 = Calculate(SUM('Table'[Amount]) ; All(Calendar) ; 'Claendar'[Year] = 2014)
    Sales Amount 2015 = Calculate(SUM('Table'[Amount]) ; All(Calendar) ; 'Claendar'[Year] = 2015)


    / J

5 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago
    Hi Anonymous ,
     
    As tex628 said before, You can try to cancel visual filter and create a calculated column or measure to display the sales volume of each year
     
    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank you both for your answers. I was looking for an answer if this is a standard behaviour or a bug and if this is somehow configurable, because none of my team was aware of this behaviour. Canceling the crossfiltering between visuals wasn´t an option. The solutuion in the customer report, not this sample from the november update report, was indeed using measures to satisfy the customer needs.

  • tex628's avatar
    tex628
    Community Champion
    6 years ago

    I think you can solve this by editing interaction between the two tables:



    Select a visual and then click "None" on the other:

    Do this on both.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      The visuals should be able to filter each other. If I click on a product on the right visual I want the left visual showing the same product. This is just an easy example of this behaviour which I had at a customer report and I was wondering if this is a normal behaviour or not.

      • tex628's avatar
        tex628
        Community Champion
        6 years ago

        It's normal behaviour. When selecting it will take all the filters that are applied to the element and apply them to the other objects.

        I think you should be able to work around it with something along the lines of this: 

        Sales Amount 2014 = Calculate(SUM('Table'[Amount]) ; All(Calendar) ; 'Claendar'[Year] = 2014)
        Sales Amount 2015 = Calculate(SUM('Table'[Amount]) ; All(Calendar) ; 'Claendar'[Year] = 2015)


        / J