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)
Very simple idea, this option is available in Qlikview so I am surprised it is not available in PBI: Conditional hide. Hide an entire visual based on a formula or value. I know you can change text, values, fonts and background based on conditions, but this is not the same. A simple conditional hide would bring a whole new level on interactivity to PBI.
RE: Visibilty (Hide an Item)
This feature would be extremely valuable, surprised it's not already in
RE: Visibilty (Hide an Item)
When will we final get this important feature?
RE: Visibilty (Hide an Item)
I just don't understand why this is not already a feature. Almost every reporting tool has this feature. There are so many times you don't want to play around with bookmarks for simple things like making a slicer available or unavailable based on RLS.
RE: Visibilty (Hide an Item)
Yes it would be extremely handy
RE: Visibilty (Hide an Item)
Any plans yet ? seems very usefull
RE: Visibilty (Hide an Item)
This is very critical in improving user experience by many folds. Making masking work arounds with a card visual is not at all so elegant. Power BI should give it out of box.
RE: Visibilty (Hide an Item)
It is an absurd Power BI doesn't have such a feature ... this is available in every other BI / reporting tool. It should be a feature in the Power BI level above the vizual level, I mean, regardless the vizual type, if native or custom, there should be the option to hide or present the vizual based on a DAX measure. The idea is to do something like, if context A, I need my vizual to be type X, if the context is B, I need to present the data in a totally different type Y.Thanks
RE: Visibilty (Hide an Item)
Hide / Show the visual based on dax measure would be really helpful. Many options would be available.This is really critical in developing the reports and making Power BI solution so flexible.
RE: Visibilty (Hide an Item)
To me this functionality should be integrated to PBI to avoid fiddling around with "Excel-Hack-Like" workarounds.Those have already been used in the last century. Imagine the digital transformation discussed everywhere is using a suboptimal analog handling resulting like that. This leads only to a suboptimal digital process.If a data given condition is made available e.g. in a measure, it should be possible to use it as a property of a visual / a page to set visibility.E.g. dashboard from an error report shows only counts of errors. If all possible errors are 0 there is no need to show an extra table-visual with an empty list or the extra page documenting the errors (becuse the visual would be empty as well).Thank you.