Skip to main content
Microsoft Idea

Power BI

Needs Votes

ability to show/hide visuals based on conditionals

Vote (600) Share
Pedro Innecco's profile image

Pedro Innecco on 15 Jan 2016 03:26:24

The idea is to allow specific conditions of data from a visual to impact the visibility of another visual.

For example if data in one visual greater than X, then hide Visual A.

I understand that such functionality would introduce the need to name visuals in PowerBI -- but this is not different than Excel, and would perhaps introduce the ability to manipulate visuals even further.

Comments (35)
Pedro Innecco's profile image Profile Picture

Tony Duguid on 11 Oct 2023 02:18:15

RE: ability to show/hide visuals based on conditionals

@Microsoft, any update on this?

Pedro Innecco's profile image Profile Picture

Ben Girard on 16 Mar 2023 03:52:53

RE: ability to show/hide visuals based on conditionals

Please merge this item with https://ideas.powerbi.com/ideas/idea/?ideaid=d29f1752-8129-4f50-af85-d336da28cac1

Pedro Innecco's profile image Profile Picture

Ben Girard on 16 Mar 2023 03:51:45

RE: ability to show/hide visuals based on conditionals

Like other Microsoft forums, it's an idea cemetery. Similar suggestions are not managed and merged, thus further splitting the votes. No updates as to the status (reviewed, in-progress, won't do, etc..) Participation is nearly pointless unfortunately.

Pedro Innecco's profile image Profile Picture

Ben Girard on 16 Mar 2023 03:49:14

RE: ability to show/hide visuals based on conditionals

3 years later, still not enough votes to be built-in or being worked on... depressing.

Pedro Innecco's profile image Profile Picture

Eric Klamm on 02 Dec 2020 16:20:44

RE: ability to show/hide visuals based on conditionals

This function is important to dynamic report design. The workaround for adding a transparent card overlay works for limited use cases, and only allows for one visual behind the card. The option to display a range of different visuals based on a calculation would enable some very dynamic report builds.

Pedro Innecco's profile image Profile Picture

Arpith Neelavara on 19 Oct 2020 03:18:25

RE: ability to show/hide visuals based on conditionals

This can be achieved with the following approach:
1. Add a card visual and make the layer order of the card such that it comes after the visual above which it is placed.
2. In the original visual which is now above the card, add conditional formatting for the background. This conditional formatting should be based on a field value (create a measure that returns the color code).
3. The measure used would be something like below:
Measure =
IF(
,
"#FFFFFF",
"#FFFFFF00"
)

Pedro Innecco's profile image Profile Picture

Power BI User on 06 Jul 2020 00:12:14

RE: ability to show/hide visuals based on conditionals

In Business Objects it is possible to show/hide visuals based on a formula

Pedro Innecco's profile image Profile Picture

John Reilly on 06 Jul 2020 00:10:37

RE: ability to show/hide visuals based on conditionals

Really important. Workaround of overlaying a card with conditional transparent background is really not workable because it takes focus and you can't interact with the visual underneath it.

Pedro Innecco's profile image Profile Picture

jeffrey Weir on 06 Jul 2020 00:09:38

RE: ability to show/hide visuals based on conditionals

This idea for the same thing (i think) has 1400 votes: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/14126904-dynamic-visibility

Pedro Innecco's profile image Profile Picture

Power BI User on 06 Jul 2020 00:09:21

RE: ability to show/hide visuals based on conditionals

this functionality should have been available from the very beginning!