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)
I used this all the time in SAP BO WebI. It would be very helpful to have this functionality in Power BI. Use case, a graph displays category. If the user selects one category in a slicer, the category graph is hidden and the subcategory graph is displayed. This makes more use of the space by eliminating the display of a graph with one value. Just one example.
RE: Visibilty (Hide an Item)
Please - implement this. This is huge because it gives the developer so many options - e.g. pictures , conditionally showing of hiding charts e.g. It has thousands of implementations
RE: Visibilty (Hide an Item)
Would be so great.
Example in my case.
I have a line chart with 7 lines, what is already quite charged.
But we would also need by type the moving average and target.
But I would only show these if one of the 7 categories is selected.
So at that moment we would show 3 lines ....
The value itself, the moving average, the target ...