Forum Discussion

ginowms0405's avatar
ginowms0405
Frequent Visitor
4 years ago

Inquiry About Hiding, Resizing, or Repositioning Visuals Dynamically

Hello, I am new to doing advanced Power BI development and have a question about the capability of resizing visuals dynamically. I have a report that displays cards and gauges in 5 columns. Each column reflects a production line. If a production line is either inactive or complete, I'd like to hide that column and potentionally resize any of the active columns. The report will display on a large monitor in a warehouse and will refresh every 15 minutes, as the report will be setup with a DirectQuery connection. I have searched via the web and Power BI Community to see if anyone else has posed such a scenario.

 

To give an example of what I am attempting, I have attached a photo of counts and progress associated with 5 production lines for a product. In the graphic, 4 lines are reporting activing. The fifth line is not. With the display being on a larger monitor, dynamically enlarging the remaining production line information would fill in empty real estate on the monitor. In addition to resizing, I'd have to dynamically reposition lines so that they float to keep from overlapping. Is this something better that may be served as a front-end solution (e.g., C#)? I have not been able to find anything on auto-resizing and auto-positioning. Thanks in advance for any information.

Sample Display of Production Lines

1 Reply

  • ginowms0405 you cannot dynamically resize/reposition the visual, but if some DAX tricks and conditional formatting you can show the message instead of showing the blank visual. Check video on my YT channel on how to show message with conditional formatting.

     

    https://youtu.be/1Szb7h_3fE4

    https://youtu.be/I64CJKvegvk

     

     

    Follow us on LinkedIn and  to our YouTube channel

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.