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)
There is a need for inbuilt capability to for setting up show/hide rules on visuals, so that certain visuals will only appear in the report once the condition is met.
Excelerator BI has an excellent blog article on a workaround for conditionally show/hide a visual based on a slicer selection, but this doesn't meet every desired need.
It would be fantastic if rather than having to be cleaver with implementing layered visuals to mask and unmask, one could simply define expression based formatting rules where once these rules are met, the visual becomes visible.
This could be implemented similar to how the Format by Field Value works for conditional font color formatting, etc.
RE: Visibilty (Hide an Item)
It would be great to be avle to show and hide a visualisation based on a measure.
F.ex. if a surten condition = true the show or hide a visualisation.
F.ex. through a switch statement different visualisations can be displayed depending on what the user selects or if a certain condition = true
RE: Visibilty (Hide an Item)
The idea is to be able to hide or unhide a slicer based on a specific condition, that might be a value selected from another slicer, or a value selected from another visual, or the value returned from a measure.
The reason is that sometimes not al the visuals are needed on a dashboard, and this would help to better fit the other visual's size on a page.
RE: Visibilty (Hide an Item)
Now we can implement this behaviour using a card to hide the visual. The order of the visuals (front to back) needs to be: the card then the visual to show/hide. To hide dynamically the card by a measure I can only use background but when the card (front) is transparent I cannot perform the interactions with the visual (back).
Only if the card is hidden (using selection pane) the visual is repsonsive.
The solution could be to bind show/hide property (the same that is used in the selection pane) to a specific measure.
RE: Visibilty (Hide an Item)
Just as Scott mentioned, this is trivially easy in Qlik products. Coming from a Qlik background, and now trying to replicate this functionality in PBI, is a bit frustrating!
RE: Visibilty (Hide an Item)
This is an absolute must have. Super easy in QlikView and QlikSense. I'm very surprised there isn't a conditional visibility as a standard feature of visuals.
Please, please, please add this feature!
RE: Visibilty (Hide an Item)
We really need this! So many report scenarios that call for this functionality especially when selected data is insufficient for certain visuals.
RE: Visibilty (Hide an Item)
There is now conditional formatting being added to all sorts of formatting properties on a visual, but not on a high level property controlling visibility! Allowing this would be MUCH easier and tidier than messing around with buttons and bookmarks (that quickly become unmanageable and error prone), as well as covering scenarios that bookmarks don't.
RE: Visibilty (Hide an Item)
I really need this feature. We have it in Charticulator. Why not in other visuals?