Let's talk about an upcoming change for Power BI Desktop and how it can be deployed. If you use Office 365, it may get a lot easier for you! David Eldersveld https://twitter.com/dataveld Twitter Thread https://twitter.com/dataveld/status/1576359796449902592 Power BI in Office installer https://learn.microsoft.com/power-platform-release-plan/2022wave1/power-bi/power-bi-office-installer
We tell you to push your transformations upstream as much as possible. But you don't know how to write SQL. That's ok, let Power Query do it for you to move your project forward. Patrick shows you how!
You can do amazing things in Power Query! Maybe you think to create a function. But do you really need a function for that? Or is it over complicating things?
From Power BI Desktop, to Task Manager, to different spots in the Power BI service - why are the sizes different? What's going on? How can you tell what the real size is? Well, it depends! Marco Russo joined Patrick to explain.
The base tooltips in Power BI are fine. But are you overusing them? Adding everything to them in your visuals? Adam gives you some things to think about with your tooltips! Create tooltips based on report pages https://docs.microsoft.com/power-bi/create-reports/desktop-tooltips?tabs=powerbi-desktop
Prioritizing questions around visualizations, design, etc... 📢 RULES FOR Q&A: 📢 👉 Put a "Q:" in front of your comment to help us identify questions! 👉 Super chats take priority 👉 Do NOT re-post your questions! We'll get to as many questions as we can. 👉 If you SPAM your question, you will be put [...]
You are excited about Field Parameters in Power BI, but then realize you can't use conditional formatting with them. What the french toast! Don't despair! Patrick and Adam have some ways to get this working. Matthias K. Question https://youtu.be/ksmNfa_K8GQ?t=1011 Let report readers use field parameters to change visuals (preview) https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters Apply conditional formatting in tables [...]
Want to optimize performance in Power BI? Of course, you do! In order to do that, you need to understand the two caches that are at play and how they affect your optimization efforts. Marco Russo helps explain! DAX Studio 3 https://daxstudio.org Connect with SQLBI: Website: https://sqlbi.com YouTube: https://www.youtube.com/sqlbi Marco Russo: https://twitter.com/marcorus Alberto Ferrari: https://twitter.com/FerrariAlberto
You have different options in Power BI when it comes to slicers and filters. Just put the slicer on the report, use a slicer panel or have them in the filter pane. But which one is faster??? Patrick explores a few scenarios to think about! Should you hide the filter pane in Power BI? https://greyskullanalytics.com/should-you-hide-the-filter-pane-in-power-bi/
Struggling with field parameters and hierarchies in Power BI? They just don't work! Patrick has an approach that looks to simulate hierarchies by using field parameters in this way. Let report readers use field parameters to change visuals (preview) https://docs.microsoft.com/power-bi/create-reports/power-bi-field-parameters
