Skip to main content

Power BI

Planned

Visibilty (Hide an Item)

Vote (2000) Share
Luca Gualtieri's profile image

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)
Luca Gualtieri's profile image Profile Picture

Farshideh Sadrhashemi on 17 Mar 2021 07:18:04

RE: Visibilty (Hide an Item)

We need to hide or show a slicer based on another selection

Luca Gualtieri's profile image Profile Picture

Arun Mallick on 23 Feb 2021 09:07:24

RE: Visibilty (Hide an Item)

I agree. Instead of providing bookmarks hide and show feature and then associate that with an action, the whole process is very complicate. Instead, why can't Power BI just make it as expression based i.e. based on an expression value, any visual can become hidden or visible. Simple and straight forward.

Luca Gualtieri's profile image Profile Picture

Ian Macmillan on 04 Feb 2021 23:01:01

RE: Visibilty (Hide an Item)

The workaround of applying a 'mask' visual is cumbersome. This functionality would definitely be very widely used.

Luca Gualtieri's profile image Profile Picture

Eric Klamm on 11 Nov 2020 15:22:35

RE: Visibilty (Hide an Item)

Dynamically driven visibility (and bookmarks) would add a ton of layout flexibility. It will also allow developers to customize views depending on what the data is saying.

For example, lists that look great when there is a lot of data in them look terrible when there are only a few rows and then a lot of white space. The ability to turn on a secondary visual to fill the space would make the layout much cleaner.

Luca Gualtieri's profile image Profile Picture

Yogendra Bhardwaj on 06 Nov 2020 00:59:11

RE: Visibilty (Hide an Item)

Please add this feature. This is very smart and useful!

Luca Gualtieri's profile image Profile Picture

Carlos Beltran Hortelano Sancho on 25 Oct 2020 10:17:01

RE: Visibilty (Hide an Item)

This would be an amazing feature. I have some visualizations in my dashboards that doesn't need to be shown unless a slicer is selected.

Luca Gualtieri's profile image Profile Picture

Eric Whitt on 29 Aug 2020 01:33:05

RE: Visibilty (Hide an Item)

We need to be able to alter the content based on what is selected from a slicer/filter, not just via an explicit button to load a bookmark. Perhaps even automate a button push (where the button's action=bookmark) when some specified selections are made. There are at least 5 Ideas for this with varying titles. Please consider all when counting votes. Thanks.

Luca Gualtieri's profile image Profile Picture

Eric Whitt on 29 Aug 2020 01:32:00

RE: Visibilty (Hide an Item)

We need to be able to alter the content based on what is selected from a slicer/filter, not just via an explicit button to load a bookmark. Perhaps even automate a button push (where the button's action=bookmark) when some specified selections are made. There are at least 5 Ideas for this with varying titles. Please consider all when counting votes. Thanks.

Luca Gualtieri's profile image Profile Picture

Eric Whitt on 29 Aug 2020 01:31:10

RE: Visibilty (Hide an Item)

We need to be able to alter the content based on what is selected from a slicer/filter, not just via an explicit button to load a bookmark. Perhaps even automate a button push (where the button's action=bookmark) when some specified selections are made. There are at least 5 Ideas for this with varying titles. Please consider all when counting votes. Thanks.

Luca Gualtieri's profile image Profile Picture

Eric Whitt on 29 Aug 2020 01:28:45

RE: Visibilty (Hide an Item)

We need to be able to alter the content based on what is selected from a slicer/filter, not just via an explicit button to load a bookmark. Perhaps even automate a button push (where the button's action=bookmark) when some specified selections are made. There are at least 5 Ideas for this with varying titles. Please consider all when counting votes. Thanks.

Merged Idea (29)