Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 to filter 2 and 3 will be static. This is what I want to achieve.
At the same time, when I apply filter 2 and 3, the charts link to filter 2 and 3 will not response based on its filter while charts link to filter 1 will response. This is not what I want.
Here is the dashboard
https://drive.google.com/file/d/1gDi_7u3YvZ1TTiocAWOuoEXHsINQiUnF/view?usp=sharing
Solved! Go to Solution.
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 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Hi @alvin199
Click on a visual, go to Edit Interactions in the ribbon, and then you can choose which filters / visuals interact with one another.
Here is a link to further explain: https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Thanks,
Theo
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
hi @TheoC
I have tried using the Edit Interaction. When I started on filter 1, the result is when I disable the interaction on charts that belong to filter 2 and 3, I cannot use filter 2 and 3. My dashboard is "half paralysed".
Anything I miss out here?
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 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Hi @TheoC
Your suggestion does work. Putting the variable name in ALLEXCEPT means remove filter on other variable & remain filtering effect on that variable.
However, directly diable the interaction by clicking on Edit interaction is faster.
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
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
58 | |
45 | |
42 |