In this video, Patrick shows you how to combine Power BI Report Tooltips using DAX. Just a little bit of DAX! This can be useful when you want to use a single report tooltip for multiple Power BI visuals.
In this video, Marco Russo, from SQL BI, joins Patrick to look at how you can debug DAX using variables in Power BI. Marco helps to break down a DAX measure and show how you can see the results as you build it up to find where the problem is. SQL BI DAX Formatter DAX [...]
Compound Growth using DAX (@ExceleratorBI) Power BI and Excel; More than just an Integration (@Rad_Reza) Drill Down & Up in Power BI Mobile apps Join the Power BI team at Microsoft Build USAFacts breaks down government financial data with Power BI BONUS ITEMS: DAX Best Practices (@marcorus) DAX Optimization Examples (@marcorus) Reordering Multiple Columns With [...]
In this video, Adam looks at how to create a Power BI date table using DAX. The end result uses a combination of the GENERATE(), ROW() and CALENDARAUTO() DAX functions to create a calculated table resulting in a Power BI date table. Using GENERATE and ROW instead of ADDCOLUMNS in DAX
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 and Patrick discuss their travels, including PASS Summit 2017. They also discuss the new Azure AD B2B support for Power BI. They sit down with Marco Russo to discuss a little DAX and catch up on things. Travels: 0:07 PASS Highlight: 3:23 News about Adam: 9:58 Azure AD B2B with Power [...]
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 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
Use Multiple Connections Between Tables (@PowerBITips) The ALL() Function in DAX (@ExceleratorBI) Responsive visualizations coming to Power BI Power BI Desktop July Feature Summary Power BI Service and Mobile June Feature Summary BONUS ITEMS: Data Privacy Settings In Power BI/Power Query, Part 4: Disabling Data Privacy Checks (@Technitrain) Integrate Power BI into Your Application: Part [...]
In this video, Patrick shows why you may hit some issues with time calculations and how to fix time. He typically sees this when using a Data Warehouse.