Forum Discussion
Cluster and strippet visual interactions
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:
3 Replies
- amitchandak
Super User
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?
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
Community Support
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
