Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup176 2 Minute Tuesday: https://guyinacu.be/priad Patrick's tech video: https://guyinacu.be/modelviewtips Adam's tech video: https://guyinacu.be/9thingstoknow 🔴 Live replay: https://guyinacu.be/April2020Recap 📢 Become a member: https://guyinacu.be/membership Sources Custom KPI Card with Color Status Bar and Details (Twitter | LinkedIn) Global Azure 2020 goes Virtual [...]
The model view, in Power BI Desktop, is really powerful. Patrick shares 3 tips that you may not have known about.
Thanks for watching this week's Power BI news roundup! 2 Minute Tuesday: https://guyinacu.be/createhierarchy Patrick's tech video: https://guyinacu.be/3favoriteoptions 🔴 Live Stream Replay: https://guyinacu.be/whyatablelive 📢 Become a member: https://guyinacu.be/membership Sources Utilizing Power BI to connect to Open Data sources: COVID-19 Reporting (Twitter | LinkedIn) Power BI Governance – Why you should consider to disable [...]
Power BI has a lot of options you can set. Here are Patrick's 3 favorite options in Power BI Desktop!
Learn to easily create a hierarchy in Power BI. This seems to be a new way that snuck into Power BI Desktop!
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup174 2 Minute Tuesday: https://guyinacu.be/coalesce Patrick's tech video: https://guyinacu.be/pbidesktop Sources 7 TIPS FOR ENSURING SUCCESSFUL BUSINESS INTELLIGENCE ADOPTION (@BlueGraniteInc) Obtaining accurate totals in DAX (@marcorus) Analysing Dataset Refresh In Power BI Premium Using SQL Server Profiler (@cwebb_bi) Power BI Service [...]
Getting started with Power BI Desktop is easy! Patrick looks at 5 steps to get you up and running quickly with Power BI Desktop. From downloading, to getting data, and then building your report visuals. Getting started with Power BI Desktop https://docs.microsoft.com/power-bi/desktop-getting-started https://docs.microsoft.com/power-bi/guided-learning/gettingdata#step-2 Introduction to modeling your data https://docs.microsoft.com/en-us/power-bi/guided-learning/modeling#step-1
Learn how to get default values using the DAX COALESCE function instead of IF statements. A great way to avoid BLANK in Power BI! Documentation: https://docs.microsoft.com/dax/coalesce-function-dax SQLBI.com article: https://sql.bi/659297
Are your Power BI Aggregations not matching? Setting Precedence can control which Power BI aggregation will be preferred. A little hint to help it on its way! Documentation: https://docs.microsoft.com/power-bi/desktop-aggregations#aggregation-precedence
Power BI buttons got a little more power! Navigation actions for Power BI buttons really streamline your reports and no longer require bookmarks. Power BI Desktop Samples: https://github.com/microsoft/powerbi-desktop-samples