Display updated chart visual and legend based on slicer

[ce138867]

Hi All,

I've got a slicer and I want to be able to update a cluster chart visual based on the selection but I need it to dynamically update both the Y axis counts but the legend display as well. Is this possible?  I've been reading the posts about parameters but not sure how it applies to this as well as a few posts regarding dynamic setup.

BTW, this is using a shared semantic model in which I'm trying to define this to the needs of our dept.

[ce138867]

I found out what the issue was. The semantic model I was using had parameters and when I pulled them into my report the parameters didn't pull through. They still displayed but did not have the parameters indicator. Are they supposed to? 

I had to recreate the parameters in my report which didn't update the semantic model as these were considered import, not direct query, and when using them in the visual, it displayed the information appropriately.

Since I'm not allowed to attach to posts, I'll post the link on the use of parameters. @Anonymous I did use the bookmark features for something else to hide/display visuals. thank you!

[Anonymous]

Hi @ce138867 

You can create some visuals and save their visibility properties using bookmarks, which can then be used to switch between them.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ritaf1983]

Hi @ce138867 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly