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/
In this video, Patrick shows a way you can use parameters and templates, with Power BI Desktop, to provide prompts for your connection's server and database properties. This is great for when you are creating a report, and need to share it with a customer that may have a different name for the server and [...]
In this video, Patrick shows how you can successfully connect to your SQL Server Always On Availability Group (AG) Secondary Read Replica using Power BI Desktop and the On-Premises Data Gateway. Adam jumps in to show you what the connection string looks like when you use this approach. Configure Read-Only Routing for an Availability Group [...]
Hurricane Harvey Donations: American Red Cross Salvation Army Humane Society Hurricane Harvey Relief Fund Roundup Items: Context Transition in DAX/Power BI: A Visual Guide (@csgpro) Multilanguage Multilingual reports in Power BI (@CurbalEN) Introducing per-user usage metrics: know your audience and amplify your impact Create interactive timeline visualizations for your data with the new timeline storyteller community [...]
Changing the culture of a Power BI Desktop file (@marcorus) Solar Eclipse 2017 In Power BI (@datachant) Power BI Developer community August update Power BI On-premises data gateway August update Show us your creative What If and win swag! BONUS ITEMS: PREPARING FOR MICROSOFT CERTIFICATION EXAM 70-778: ANALYZING AND VISUALIZING DATA WITH MICROSOFT POWER [...]
In this video, Patrick looks at the ragged hierarchy problem within Excel and Power BI when you are pulling data from Analysis Services. He looks at how you can correct the issue easily within Excel and some alternatives for Power BI.
In this video, Patrick shows how you can fix quick measures that break when you use dates with time calculations. Patrick referenced a blog from Kasper de Jong. You can find that here: Use the Power BI quick calcs with your own date table