Forum Discussion

sshweky's avatar
sshweky
Icon for Helper III rankHelper III
10 years ago

Conditional visibility of a visualization in Power BI report

Is there any way I can make a visualization appear only if a certain condition is true?

Need Help

5 Replies

  • MattAllington's avatar
    MattAllington
    Icon for Community Champion rankCommunity Champion
    10 years ago

    I don't believe so,  But here is an idea.  If someone could copy the Image code and add a binary option to turn the image on/off based on some measure.  Then you could put a white box over another visualisation and have it appear or disappear.  So now all you need to do is find a developer that can do this.

     

    https://app.powerbi.com/visuals/

    • konstantinos's avatar
      konstantinos
      Icon for Memorable Member rankMemorable Member
      10 years ago

      Depends the visual and the condition..I have done something similar  for a bar chart to show up only when a slicer value is selected. 

      Actually it does't shows up , it is there BUT if you remove the chart  axis, titles and labes and the values are blank it seems like there is no chart., shows nothing. Not ideal on all situations but is a workaround.

       

      The condition can be a filter/slicer value or even a number on sales..

      Modify your measure to something like below to fit your condition

       

      Shows on filter =
IF ( VALUES ( Clients[name] ) = "Kostas"; [YourMeasure] )


Shows on Value =
IF ( [Sales] > 1000; [YourMeasure] )

      Hope it helps

  • Gianluca88's avatar
    Gianluca88
    Icon for Resolver I rankResolver I
    4 years ago

    Hi all,

     

    any news about this interesting topic, I mean the possibility to hide/show a visual dynamically by means of a meaure for example. At the moment, a possible workaround is using a bookmark for example, but it is quite frustrating since we forced the user to perform an unuseless selection with a bookmark botton.

     

    Thanks,

    Gianluca