Forum Discussion

alvin199's avatar
alvin199
Icon for Helper III rankHelper III
4 years ago
Solved

Disable certain chart with multiple filters in a dashboard

Hi, here is my dashboard and I would like to only allow each of the 3 filters to interact with the charts that link by red link. If I disable the charts that link to filter 2 and 3, the charts link ...
Need Help
  • TheoC's avatar
    TheoC
    4 years ago

    Hi alvin199 

     

    Unfortunately, that is how the Edit Interactions work. The other way to do it is to create a measure that includes ALLEXCEPT (https://docs.microsoft.com/en-us/dax/allexcept-function-dax).

     

    If you use CALCULATE ( [Measure] , ALLEXCEPT ( Table, Table[Column1] , Table[Column2], etc ) ) you will be able to ignore every filter except the columns that you put in the ALLEXCEPT function.  

     

    Let me know if that makes sense. Take a look at the link and let me know how you go k.

     

    Theo 🙂

     

TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

Hi alvin199 I though you mentioned Edit Interactions didn't give you what you needed?

 

Either way, I hope it gets sorted mate!

 

All the best!

Theo

 

alvin199's avatar
alvin199
Icon for Helper III rankHelper III
4 years ago

Yup, I have to use ALLEXCEPT method in my case. However, if there is an option, I still prefer to use the Edit Interaction method.