Slicers - Still show "items with no data"

[patrick3]

Hi community,

So I'm building a report with multiple slicers - using one slicer should filter and leave visible only items with data for the other slicers, otherwise it's virtually unusable. 

Multiple solutions suggest to have "Cross filter direction" set to "Both" - but in my report I can only ever do that to 1 relationship, whenever I try to do it for another relationship I get the following warning (with column names being changes depending on which filter I use):

It could be because of the way the model is built and the relationships are setup - i'm pretty much just playing around learning by doing which got me to this point (same structure worked perfect in PowerPivot models):

I've circled in red the tables i'm using as slicers in this particular report.
The metrics used in the report are created from both the bigger tables on the right and sometimes a combination.

Hope someone can point me in the right direction.

Thanks,

Patrick

[v-shex-msft]

HI @patrick3,

This is a general error message which appears when your data model contains multiple available relationships.(power bi can't confirm which relationship to link tables)

Please take a look at below link about similar issues.

Bi directional cross filtering/ambiguity

Regards,

Xiaoxin Sheng

[patrick3]

Hi Xiaoxin,

Thanks for your reply.

I'm not sure how those links help my particular slicer issue to be honest?

Thanks,

Patrick

[v-shex-msft]

HI @patrick3,

Actually, you not need to configure complex relationship in power bi. Power bi will auto link data tables with existing relationships.

That link also told about this. so my suggest is cut down current relationships and keep the less amount which power bi can analysis and link to each tables.

Regards,

Xiaoxin Sheng

[patrick3]

Hi @v-shex-msft,

Not sure I follow - as far as I know, I've the least amount of relationships needed per my requirements.
Appreciate your help - maybe what I'm asking for is just not possible.

Thanks,

Patrick

[v-shex-msft]

HI @patrick3,

Actually, this issue is caused by multiple available relationships, power bi can't ensure which relationship available.(different relationship keys can cause different records mapping of tables)

Since power bi not support many to many relationship, so you can also turn off some relationship and keep only one available relationship link to each tables.

Regards,

Xiaoxin Sheng