Control a visual through filter from a second visual

[learn_powerbi]

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? 

[OwenAuger · Accepted solution]

Hi @learn_powerbi 

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?

[learn_powerbi]

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?

[learn_powerbi]

I tried again and had to change the interaction setting and now it works! thank you