Thanks for watching this week's Power BI news roundup! Patrick's tech video: https://guyinacu.be/toomanyrows Patrick's 2nd tech video: https://guyinacu.be/visualdataprep 📢 Become a member: https://guyinacu.be/membership Sources Spot the difference between Power BI Desktop and Power BI Desktop (Store Version) (@donsvensen) Which Way to the Right Map in Power BI (@DataTaleAU & @CSGPro) Dynamic "Column" [...]
Too many rows? How is that possible? Patrick looks at a case where a customer hit an error of too many rows coming back from a DAX statement in Power BI.
Just starting with Power BI? Maybe you've been using Power BI for a while and have hit a wall. We wanted to call out some items that help with a lot of conversations we have over and over again. Take your skills to the next level! Star Schema Guidance: https://docs.microsoft.com/power-bi/guidance/star-schema Star Schema A Complete Reference: [...]
Thanks for watching this week's Power BI news roundup! Patrick's tech video: https://guyinacu.be/whyusedaxstudio Adam's tech video: https://guyinacu.be/p2wupdates 🔴 Live Replay: https://guyinacu.be/live031 📢 Become a member: https://guyinacu.be/membership PASS Summit 2020: https://www.pass.org/summit/2020/ What is Power BI Doing to My Database?: https://www.pass.org/summit/2020/Learn/Session-Details/name/what-is-power-bi-doing-to-my-database/sid/108547 Brand Building Panel Discussion: https://www.pass.org/summit/2020/Learn/Session-Details/name/brand-building-panel-discussion/sid/108940 Sources Important Links every Power BI enthusiastic should [...]
Are you using DAX Studio with Power BI? Patrick shows you why you should consider using it when working with DAX for Power BI! DAX Studio: https://www.sqlbi.com/tools/dax-studio/
Replay of live stream with Marco Russo and Alberto Ferrari from SQL BI. 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 Questions answered in stream Q: Is it possible to show 2 lines on the line chart for 2 different months? If yes how do u ensure [...]
Take Power BI Conditional Drill to the next level by incorporating Paginated reports with your strategy! Patrick shows a customer scenario that he solved using this approach. Paginated reports doc: https://docs.microsoft.com/power-bi/paginated-reports/paginated-reports-report-builder-power-bi Power BI Report Builder: https://docs.microsoft.com/power-bi/paginated-reports/report-builder-power-bi Conditional Drill video using buttons - https://www.youtube.com/watch?v=4Qy-bksqExI
There are different interactions Power BI visuals can have, but how do we conditionally highlight a bar in a Power BI report using a slicer? Patrick shows you some MAGIC to get this to work. Question from Live Stream Phil Seamark's Blog Edit Interactions Documentation Conditional formatting Download Sample
How do you work with time periods in Power BI like last month? Patrick digs in to show how you can accomplish this with a little DAX.
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup193 Patrick's tech video: https://guyinacu.be/nextleveldatepicker Adam's tech video: https://guyinacu.be/msaccess 📢 Become a member: https://guyinacu.be/membership Sources How to set a DATE SLICER to TODAY by default in Power BI (@HowToPowerBI) Embedding Hover Effect Tooltips to a "Card" Visual in Power BI [...]