Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
@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?
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
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |