Forum Discussion
Helper IHow to hide a visual based on slicer
My need is the same as the original poster.
I have seen this video, it is very helpful and I have made the toggle button. But what I really want is the charts to change visibility, not when the user clicks the button, but when the user changes a value of a slicer.
Is there a way to change the visibility of a chart based on a slicer value? (not by clicking a button)
Thanks.
Hi Chrisdorrian,
Got your point now. There is no such properties to set it up the views of your report.We have action property only for images and buttons and not for the values from the slicers.
If your slicer has only minimum values say 2 to 5, then you can assign these values statically for buttons or images and play around with this.
If you have more than 5 values and its changing oftenly, then there is no way to get this implementation.
Regards,
Pradeep
Anonymous wrote:Hi Chrisdorrian,
Got your point now. There is no such properties to set it up the views of your report.We have action property only for images and buttons and not for the values from the slicers.
If your slicer has only minimum values say 2 to 5, then you can assign these values statically for buttons or images and play around with this.
If you have more than 5 values and its changing oftenly, then there is no way to get this implementation.
Regards,
Pradeep
Pradeep, you describe exactly what I need to do: "If your slicer has only minimum values say 2 to 5, then you can assign these values statically for buttons or images and play around with this."
In my case, I have a user table, and we have a column which identifies each user as either "standard" or "premium". We then have a button which they can click. If they're premium, it takes them to another page with some visuals. If they're standard, it displays a message on the button (or could take them to another page) which says "this feature isn't available to standard users".
So basically I only have two values to deal with (standard or premium) which control which of those buttons (and thus actions) are visible and available to the user. So the last piece I'm trying to figure out is "then you can assign these values statically for buttons"
Can you please explain how I assign those values to buttons? I don't see an option to do that, the button is just tied to a bookmark, I can't figure out how to get the data involved. Basically the user should pick a value from the user_id slicer, that will tell power BI whether they're standard or premium, and from there it should know which button to display. Is this possible?
thanks!