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.
- Comments (20)
RE: Visibilty (Hide an Item)
Please add this. Need it for so much since Apps expose quite a bit and tend to ignore security.
RE: Visibilty (Hide an Item)
This is a great idea. I was surprised it does not exist in PBI!
RE: Visibilty (Hide an Item)
This should be a must to in PBI
RE: Visibilty (Hide an Item)
QlikView has had this already for more than 10 years. I was very surprised to not find it in PowerBi. I will stick with QlikView for now.
RE: Visibilty (Hide an Item)
Please implement this idea. This will be super helpful.
RE: Visibilty (Hide an Item)
I totally agree. We are moving away from Qlikview to Power BI and I'm finding quite a few limitations
RE: Visibilty (Hide an Item)
This is essential in my option for a BI tool, please develop! Specifically if you
want to guide the user to make certain selections before visuals are displayed it is critical.
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)
Also show/hide bookmarks if ...
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.