cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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:

 

UnitedLexAdmin_0-1601422933833.png

Sampledescription table:

 

UnitedLexAdmin_1-1601422989127.png

Relationships:

UnitedLexAdmin_2-1601423028945.png

Cluster visual:

UnitedLexAdmin_3-1601423061691.png

Strippet:

UnitedLexAdmin_4-1601423123516.png

 

 

 

3 REPLIES 3
Super User IV
Super User IV

@UnitedLexAdmin , 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?

 

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

@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?

Hi, @UnitedLexAdmin 

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

 

 

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors