Power Query and a new Power BI Desktop update

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 & [...]

Download and Deploy a K12 Power BI Solution for schools

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

Fonts, Images, Power BI Contests and more…

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 [...]

Pie charts, DirectQuery and Power BI updates

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 [...]

Dynamically change chart axis in 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/

Copy Conditional Columns in Power Query or Power BI

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.

Drilling into drillthrough in Power BI Desktop

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!

Power BI Bookmarks, Selections and Toggles

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

SSRS APIs, M Queries, Power BI Desktop and more

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 [...]