Filter interaction doesn't works in Power BI desktop

[vjnvinod]

Hi Team,

I am trying to find the  reason behind my  Region dropdown list not interacting with  Outbound Matrix/table (refer the dashboard view pic) but works with Inbound matrix/table and also please have a look at the relationship i have created

Hope to find a solution for this issue

[RMDNA]

@vjnvinod,

I'd recommend blacking out client names, contacts, and any financial data in your picture.

The tables may be connected, but if you filter by Region and it doesn't directly affect HQRegion in the bridge table, or if HQRegion doesn't directly affect Outbound, you won't see any changes.

You may also want to check the Format tab and look at "Edit Interactions" to ensure the visuals are set to affect each other.

[vjnvinod]

@RMDNA

All the other Graphs/charts are coming from inbound table, edit interaction doesn't helps.

what do you suggest? i see the inbound interaction is working fine with all the charts and graphs but its not the case with Outbound

[vjnvinod]

@RMDNA

thanks again for stepping in and helping, can you please let me know how do i fix this. is it possible to set a connection between inbound and outbound table (i tried doing it, its not working, as its throwing up unique value error)

I would highly appreciate your help here.

[RMDNA]

@vjnvinod,

Could you post either a small subset of data or a scrubbed .PBIX?

[vjnvinod]

@RMDNA

Here is the scrubbed Pbix file, let me know if you are able to help.

please note that the issue is while selecting a particular region, let say northeast and then you click on the outbound value, which is not interacting with pie and the table i have highlighted right below the inbound and outbond matrix

https://www.dropbox.com/s/20u6v9kpwr6xehc/Testcheck.pbix?dl=0

[vjnvinod]

@RMDNA

just wondering, if you had a chance to check the interaction in my PBIX file shared.

rgds, vinod

[v-jiascu-msft]

Hi @vjnvinod,

If you want to interact with other fields, you may need new relationships. Please check out a demo in the attachment.

Why doesn't your current model work? As we can see the example below, whatever we select in the Outbound, all of the Inbound are hit. Because they are all connected to Northeast.

The solution could be creating more middle tables. For example, we want to interact with the field "Homeoutbond".

1. Create a table.

HomeOutbond =
DISTINCT (
    UNION ( VALUES ( Inbound[HomeOutbond] ), VALUES ( Outbound[HomeOutbond] ) )
)

2. Establish relationships.

3. Add the 'HomeOutbond'[HomeOutbond] to the visual.

Best Regards,

Dale

[vjnvinod]

@v-jiascu-msft @RMDNA

Hi Dale,

thanks for taking time and responding.

Going with the logic you have shared, i see the numbers reflecting in Pie Chart and Matrix table are the reflection of the Inbound values, not the Outbound values which is what my expected result should be (if i click on outbound value, my pie chart and table below should reflect the outbond value and same with Inbound value as well)

Please take a look at the Snapshot you have shared, quite evident from their that numbers reflecting in Pie and matrix are not correct/Not as per the expected results

if you see in your snapshot, you have selected for Northeast and then clicked on other outbound americas as a result i observed that the numbers which is reflecting in the Pie chart (282.08)& the Matrix 282.08 (account segment, acccount channel and ter_fytd_usd) are from Inbound.

I was breaking my head this morning from India, but quite not able to get their.I would highly appreciate if any workaround or solution can be provided for this mess.

Regards, vinod

[v-jiascu-msft]

Hi @vjnvinod,

What's the expected result?

I have explained in my first post. Let's have a look at below. What do you expect from the "Inbound" if we click the "Outbound" value "o2"?

So we need a middle table like NEWTABLE. When we click the values in the middle table, both of the Inbound and the Outbound tables will act.

o1

o2

o3

Best Regards,

Dale

[vjnvinod]

@v-jiascu-msft

Hi Dale,

Looks likes its an issue with Power BI, middle tables are helping only when the regions are filtered at "all" level, the interaction works perfectly fine (see below snapshot) , which is what my expected result should be (that means my outbound is interacting with inbound, pie and the table)

Expected results

Now whats happening is when i filter for any region let say Northeast and then click on other outbound americas, i am not getting the above model results (refer below screenshot), (highligting in red means, they are not interacting with Outbound values) & the numbers of Pie and matrix are not in sync(i am fine with inbound, it may match or maynot)

let me know, why my model is not working? or is it not possible to do it in Power BI? thanks for your help here.

Unexpected result

https://www.dropbox.com/s/87mgmsb7u70jloe/Testcheckdale.pbix?dl=0

[vjnvinod]

@v-jiascu-msft@RMDNA

Hi Guys,

Any help on this?

[vjnvinod]

@v-jiascu-msft@RMDNA

hi Guys,

Can anyone please help here?

Regards, vinod

[vjnvinod]

@v-jiascu-msft  @RMDNA

Hi  Dale

hope all is well!

Just wondering if you had a chance to check my query on the interaction values.?

thanks for your help!

Regards, vinod