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)
@Microsoft, is there an update to the timeline for this?
RE: Visibilty (Hide an Item)
This feature is a must have, it would allow so many possibilities. Of course, the hidden visual should not be interactable either, and should allow interactions through it (effectively, the visual should become invisibile and virtually "drop" under all the layers in the selection pane).
RE: Visibilty (Hide an Item)
When is the schedule go-live for this?
RE: Visibilty (Hide an Item)
Is there an update on this? It would save an immense amount of time and effort at our company.
RE: Visibilty (Hide an Item)
When is this sprint item planned?
RE: Visibilty (Hide an Item)
Still no updates after a year?
RE: Visibilty (Hide an Item)
Almost a year on the "upcoming roadmap" and still no sign of this functionality.
RE: Visibilty (Hide an Item)
Any updates on this? I need something that will allow me to change visualisations on a page based on selecting the group of columns in a slicer (e.g. the amount of transactions for something (5 columns) or the amount of lifts for something else (2 columns). I have tried multiple different ways and nothing works for column "groups" on a page. (don't want to create multiple pages for the same area).
RE: Visibilty (Hide an Item)
Any updates?I need the option to hide a visual based on a table value / DAX.
RE: Visibilty (Hide an Item)
Hopefully, this will also allow to conditionally hide a full page/sheet as well or allow RLS to see/hide pages.