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.
@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.
✨ 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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Power BI Monthly Update - May 2024
Check out the May 2024 Power BI update to learn about new features.
