Power Query – Consecutive Days (@PowerPivotPro) The Each Keyword in Power Query (@kpuls) Remove repeating characters from a string in Power BI and Power Query (@TheBIccountant) "In the Previous" Date Filters In Power BI/Get&Transform/Power Query (@cwebb_bi) Query folding to improve Power BI performance (@CurbalEN) Power BI Desktop January Feature Summary BONUS ITEMS: Adding Comments & [...]
In this video, Patrick shares a Power BI solution he created for K12 schools in United States education. This solution includes instructions to create views for use with the Power BI reports. It also includes a Power BI Desktop template for pre-created reports based on your school data. GitHub Repo - https://github.com/pleblanc72/K12-PBI-Attend-and-Incidents
Font Families in Power BI (@dataveld) Dynamic Attributes In A Power BI Report (@PowerPivotPro) Embedding Images in Power BI using Base64 (@SQLJason) Year in Review Contest: Jan. 3-Jan. 31 Happy New Year from Power BI Desktop BONUS ITEMS: EARLIER vs EARLIEST in DAX (@ExceleratorBI) Power BI Connections: Direct Query (@Eno1978) Regular Expressions will save your [...]
Please, no pie in the cube! (@nimrodon) To DirectQuery or Not to DirectQuery, that is the question.. (@kjonge) Power BI Desktop December Feature Summary Power BI service October and November feature summary Announcing Power BI Premium support for larger datasets BONUS ITEMS: Design Concepts To Help You Create Better Power BI Reports (@mmarie) Power BI [...]
In this video, Patrick builds on a blog post from Scott Senkeresty to dynamically change the axis of your visual within Power BI. This uses a combination of Power Query and DAX. Chris Cook - @Finalyst89 Scott Senkeresty – @ScottSenkeresty Dynamically changing chart axis http://tinylizard.com/dynamically-changing-chart-axis/
In this video, Adam looks at how to use conditional columns within Power Query and then copying them for use in other queries or Power BI Desktop files. This is a great technique if you don't want to retype all of the conditional items in the dialog in Power BI.
In this video, Patrick looks at how you can use the drillthrough feature within Power BI Desktop. He also looks at how you can drill to multiple fields at the same time. The back image can also be changed and Patrick shows you how to do it!
In this video, Patrick shows how you can use bookmarks and selections to create interesting reports to show different aspects of your data. He also shows a very cool way to change between those selections that he picked up from one of his customers. Bookmarks documentation
Exploring The New SSRS 2017 API In Power BI (@technitrain) Bulk-extracting Power Query M-code from multiple pbix files in Power BI (@TheBIccountant) Automatic installs of Power BI Desktop (@CurbalEN) How administrators can manage the Power BI Desktop sign-in form Visualizing and interacting with your Azure Machine Learning Studio experiments Congratulations to the Winners of the [...]
In this video, Patrick uses a little DAX, and the SelectedValue function, to get you some dynamic labels in your Power BI reports. For more information about SelectedValue, check out Marco Russo's blog on the function - https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/