Luca Gualtieri on 01 Feb 2019 02:44:01
Develop an item formatting property which allows to set the visibility of a report item when you want to conditionally hide the item based on a report parameter or some other expression that you specify (also DAX expressions).
You can develop this incrementally starting from visuals, then text boxes, then shapes and buttons....
If you want to go the extra mile, you can also develop a functionality that allows the final user to toggle the visibility of report items.
For more information and since it was an available and really useful capability see "Add an Expand or Collapse Action to an Item (Report Builder and SSRS)".
https://docs.microsoft.com/en-us/sql/reporting-services/report-builder/hide-an-item-report-builder-and-ssrs?view=sql-server-2017
I double checked in the ideas database and there are many ideas describing the same functionality; this is the reason why I do believe this is really required and will try to collect all the previous votes under this item.
Administrator on 18 Oct 2022 00:57:38
Update 10/17: This is now in our upcoming roadmap and we will share more details in the coming months. Mo
- Comments (133)
- Merged Idea (29)
RE: Visibilty (Hide an Item)
Excellent Idea!
RE: Visibilty (Hide an Item)
Excellent Idea!
RE: Visibilty (Hide an Item)
We need to hide or show a slicer based on another selection
RE: Visibilty (Hide an Item)
I agree. Instead of providing bookmarks hide and show feature and then associate that with an action, the whole process is very complicate. Instead, why can't Power BI just make it as expression based i.e. based on an expression value, any visual can become hidden or visible. Simple and straight forward.
RE: Visibilty (Hide an Item)
The workaround of applying a 'mask' visual is cumbersome. This functionality would definitely be very widely used.
RE: Visibilty (Hide an Item)
Dynamically driven visibility (and bookmarks) would add a ton of layout flexibility. It will also allow developers to customize views depending on what the data is saying.
For example, lists that look great when there is a lot of data in them look terrible when there are only a few rows and then a lot of white space. The ability to turn on a secondary visual to fill the space would make the layout much cleaner.
RE: Visibilty (Hide an Item)
Please add this feature. This is very smart and useful!
RE: Visibilty (Hide an Item)
This would be an amazing feature. I have some visualizations in my dashboards that doesn't need to be shown unless a slicer is selected.
RE: Visibilty (Hide an Item)
We need to be able to alter the content based on what is selected from a slicer/filter, not just via an explicit button to load a bookmark. Perhaps even automate a button push (where the button's action=bookmark) when some specified selections are made. There are at least 5 Ideas for this with varying titles. Please consider all when counting votes. Thanks.
RE: Visibilty (Hide an Item)
We need to be able to alter the content based on what is selected from a slicer/filter, not just via an explicit button to load a bookmark. Perhaps even automate a button push (where the button's action=bookmark) when some specified selections are made. There are at least 5 Ideas for this with varying titles. Please consider all when counting votes. Thanks.