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 (141)
- Merged Idea (29)
RE: Visibilty (Hide an Item)
Yes please! If we could also do the same for Groups (grouped visuals) then that would be superb.
RE: Visibilty (Hide an Item)
Appreciate it. But, regarding RLS and possible problems with selection I would say a Toogle to hide/unhide is the solution here.it is already possible to change the color of text I think, we would need just another value to be reachable through formulas
RE: Visibilty (Hide an Item)
Yes!! Often data is not available for all values in a slicer so instead of having the visuals show up blank, would be better to just hide them unless there is data to report. One hack I came up with is to use a dummy shape that masks your content and with conditional formatting, make that shape 100% transparent when some condition is met. Ideally, the size of visuals would be responsive and fill some designated area. if a visual becomes unhidden, other visuals resize to fit. that way you don't have random blank spaces on your report.
RE: Visibilty (Hide an Item)
Please allow measure to control visibility of objects. The bookmark is somewhat walkaround solution compared to other BI tools but we need a more systematic/programmatic way to achieve this. The bookmark can complement but shouldn't be a primary/only way.
RE: Visibilty (Hide an Item)
There is a need for inbuilt capability to for setting up show/hide rules on visuals, so that certain visuals will only appear in the report once the condition is met.
Excelerator BI has an excellent blog article on a workaround for conditionally show/hide a visual based on a slicer selection, but this doesn't meet every desired need.
It would be fantastic if rather than having to be cleaver with implementing layered visuals to mask and unmask, one could simply define expression based formatting rules where once these rules are met, the visual becomes visible.
This could be implemented similar to how the Format by Field Value works for conditional font color formatting, etc.
RE: Visibilty (Hide an Item)
It would be great to be avle to show and hide a visualisation based on a measure.
F.ex. if a surten condition = true the show or hide a visualisation.
F.ex. through a switch statement different visualisations can be displayed depending on what the user selects or if a certain condition = true