You may be able to write a DAX expression, but what about an actual DAX query? DAX queries can help you validate data and fine tune your DAX expressions used for Power BI. Patrick shows you how!
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.