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)
This Feature will be very useful or you can say becomes essential in some scenarios.
e.g. if Month is selected I want to show Matrix Day wise, if not then show the matrix Column wise.
Now I have to give one more button where user need to toggle, which could be avoided if this feature is enabled.
RE: Visibilty (Hide an Item)
we would like to use this feature to change the chart type if users select a single year of data (aka single x-axis) b/c the single dots that remain when a user selects 'include' on a line graph looks terrible. We could change to a pie chart.
RE: Visibilty (Hide an Item)
If you're interested in the article mentioned above:
https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/
RE: Visibilty (Hide an Item)
The security roles should be able to control component visibility in the report.
RE: Visibilty (Hide an Item)
An additional option could be to add visibility to HTML color coding, e.g. #FFFFFF00 to #FFFFFF99. Then any conditional formatting can change visibility of an object.
Especially for users that make graphs in the web interface, this would be a great feature!
RE: Visibilty (Hide an Item)
This would be so usfull on pages with multiple bookmarks. Most of my reports need to be seen by multiple organisation layouts and then with different focus i.e sales volume, sales value, sales units
Currently this ends up as a massive spiders web.
RE: Visibilty (Hide an Item)
Excellent Idea!
RE: Visibilty (Hide an Item)
Excellent Idea!