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)
or vote here:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/14126904-dynamic-visibility
RE: Visibilty (Hide an Item)
Dynamically or conditionally hiding visuals based on expressions or parameters would be awesome! Even if you had to come up with a boolean that evaluated to True/False and could tag that to an object, bookmark, or report page's visibility status would be unbelievably fantastic!
RE: Visibilty (Hide an Item)
This option would help us cut down on the pages required for our reports. Please implement this idea!
RE: Visibilty (Hide an Item)
Seems the same as: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19435267-conditional-visibility-of-a-visual-based-on-slicer Needed feature.
RE: Visibilty (Hide an Item)
Also show/hide bookmarks if ...
RE: Visibilty (Hide an Item)
This would be very useful.
RE: Visibilty (Hide an Item)
This'd be incredibly helpful. If I could hide or show a subset of report items based on a filter, I would be able to create reports that have richer, more context-appropriate detail.
For instance, the same units sold report could support people who are interested in month-over-month views (people writing board reports), and a weekly view for those in the sales team.
RE: Visibilty (Hide an Item)
Need this for one of my conversion report
RE: Visibilty (Hide an Item)
would be very useful. if variable = ... then show or hide a visual
RE: Visibilty (Hide an Item)
Please take care of this idea.
It's so obvious that the users want to hide some filters depending on the conditions.
I found some workaround (with background of a Card), but it cannot work properly with clickable items (like dropdowns).
https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/