Cluster and strippet visual interactions

[Anonymous]

I've created a report that contains a cluster and strippet browser, but when I click on the clusters it doesn't filter the browser based on the sample data I created. I'm stuck and can't figure out why. Any help is much apprecaited! 

Sampledata table:

Sampledescription table:

Relationships:

Cluster visual:

Strippet:

[amitchandak]

@Anonymous , M -M join is not a good idea. create one or more bridge tables and use those to filter the data in both tables.

refer:https://www.seerinteractive.com/blog/join-many-many-power-bi/

Or my video -https://youtu.be/Bkf35Roman8

Can you share sample data and sample output in table format?

[Anonymous]

@amitchandak 

Thanks for the reply. It's a many-to-one relationship. I'm using the following sample report as a reference and my tables are structured similarly. 

I do have null values in the [kpi_id field] which is used as a key. Will that cause issues?

[v-easonf-msft]

Hi, @Anonymous 

Not very clear.

But I  think that it has nothing to do with the null values in the [kpi_id field]. 

From you screenshot ,I guess that you may need to  add a field to the "Enable highlights"  in the Strippet.

Best Regards,
Community Support Team _ Eason