Forum Discussion
Cluster and strippet visual interactions
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?
- Anonymous5 years agoNot applicable
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-msft5 years ago
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