Skip to main content
Microsoft Idea

Power BI

Planned

Visibilty (Hide an Item)

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

Cody Martelli on 05 Jul 2020 23:52:29

RE: Visibilty (Hide an Item)

If possible I'd like to go one step further and overlay two items in one location, dynamically hiding one or the other under certain circumstances. So I may, for example, have a data graphic some time, and a message box (e.g. "No data available") at other times.

Luca Gualtieri's profile image Profile Picture

Dinu Noroc on 05 Jul 2020 23:51:21

RE: Visibilty (Hide an Item)

Good Idea. I made a measure that builds me a link to a certain page once you select an item in the report, but the link is broken (actually blank) when nothing is selected. That link is is under a button, that should not be visible as long as nothing is selected. It is confusing for the end user to have a button that he cannot use. I was forced to create a warning message (and make the report look messier) to inform the user that the button is inactive. It would be very helpful to have an option to hide the button based on measure value, or other rules and scenarios

Luca Gualtieri's profile image Profile Picture

Thiyagu Paulraj on 05 Jul 2020 23:50:42

RE: Visibilty (Hide an Item)

This feature is needed, it will help to show or hide some of the visual based on condition.

Luca Gualtieri's profile image Profile Picture

Power BI User on 05 Jul 2020 23:40:47

RE: Visibilty (Hide an Item)

Yes to both dynamically hiding visualizations as well as report pages

Luca Gualtieri's profile image Profile Picture

john on 05 Jul 2020 23:40:12

RE: Visibilty (Hide an Item)

And also to dynamically make pages of a report visible or hidden, please.

Luca Gualtieri's profile image Profile Picture

Luca Gualtieri on 05 Jul 2020 23:40:06

RE: Visibilty (Hide an Item)

Let's try to group all the votes under a more structure idea

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36697297-visibilty-hide-an-item

Luca Gualtieri's profile image Profile Picture

Luca Gualtieri on 05 Jul 2020 23:40:01

RE: Visibilty (Hide an Item)

Let's try to group all the votes under a single structured idea

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36697297-visibilty-hide-an-item

Please add ciomments

Luca Gualtieri's profile image Profile Picture

Luca Gualtieri on 05 Jul 2020 23:40:01

RE: Visibilty (Hide an Item)

Let's try to group all the votes under a single structured idea

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36697297-visibilty-hide-an-item

Please add comments

Luca Gualtieri's profile image Profile Picture

Luca Gualtieri on 05 Jul 2020 23:40:01

RE: Visibilty (Hide an Item)

Let's try to group all the votes under a single structured idea

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36697297-visibilty-hide-an-item

Please add comments

Luca Gualtieri's profile image Profile Picture

Luca Gualtieri on 05 Jul 2020 23:40:01

RE: Visibilty (Hide an Item)

Let's try to group all the votes under a more structure idea

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36697297-visibilty-hide-an-item

Merged Idea (29)