Forum Discussion
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 purposes of illustrating the problem, i will be using Power BI sample data which has 1 table called "Financials" contaiing columns for country, product, segment, sales, profit etc.
Visuals: I have 2 visuals. a bart chart and a table as shown
Problem: What I want is for the bar graph to display nothing when a product is selected in the table. I created a measure which will return blank if financials[product] is filtered or will return gross sales otherwise. I set this as the input to the Y axis of the bar graph but it always shows the chart even if I select a product on the table. Is there any way to make it work?
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?
3 Replies
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
