Forum Discussion
Solved
Control a visual through filter from a second visual
Hi, I am trying to do something seemingly simple but cannot get it to work despite many trials and research. I am thinking it cannot be done but would apppreciate any guidance. Data: For the ...
I just tried to reproduce this and got it working at my end.
A couple of things to check:
- Interaction between table & column chart is set to Filter rather than Highlight
- Measure looks something like this:
Gross Sales if Product Not Filtered = IF ( NOT ISFILTERED ( financials[Product] ), SUM ( financials[Gross Sales] ) )PBIX attached for reference.
Does this work for you?
thanks! it does work but only for your file. Even when I copy your formula for the measure in mine, it doesnt work. Is there some setting I need to change?
I tried again and had to change the interaction setting and now it works! thank you