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 (36)
RE: ability to show/hide visuals based on conditionals
Thanks
RE: ability to show/hide visuals based on conditionals
@Microsoft, any update on this?
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
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.
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.
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.
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"
)
RE: ability to show/hide visuals based on conditionals
In Business Objects it is possible to show/hide visuals based on a formula
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.
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