Need to work with hours and minutes in your Power BI report? How do you slice by that grain? Patrick shows you a way you can work with time in Power BI Desktop. Download sample report Want to download the sample Power BI Desktop report? Hit the download button below.
Patrick looks at how you can get relative dates, in Power BI Desktop, without using the relative date slicer or relative date filters. You just need to sprinkle a little DAX into Power BI Desktop to get this going!
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup137 2 Minute Tuesday: https://guyinacu.be/multiselecttitles Patrick's tech video: https://guyinacu.be/kpiscorecard Adam's tech video: https://guyinacu.be/columnprofiling SQL Saturday Atlanta: https://www.sqlsaturday.com/845/eventhome.aspx DAX Training: - https://sqlbi.com - https://www.youtube.com/curbalen - https://exceleratorbi.com.au/ - https://radacad.com/ Sources CREATE A DYNAMIC TITLE IN POWER BI (UPDATED) (@LindsayPinchot) Move Your Shared Tables to Dataflow; [...]
Patrick walks you through how you can use Power BI to build a custom KPI scorecard. The key is the UNICHAR DAX function. Demo files: https://guyinacu.be/demofiles
After the dynamic titles in Power BI Desktop video, we had questions about how to do multi-select values. Patrick shows you how to do it! Demo files: https://guyinacu.be/demofiles
Patrick shows the magic of getting cross-report drillthrough working in Power BI. He teaches you the clicks to getting this going successfully. Demo files: https://guyinacu.be/demofiles
Alberto Ferrari joins Patrick to walk through how you can use DAX to format a list of values within Power BI Desktop. This takes the concatenate values quick measure to the next level. Original Quick Measure video Alberto's article
Patrick looks at a customer scenario where he found Power BI tooltips causing report performance issues. He shows how to identify and then a possible solution.
Patrick walks you through how to use a Power BI quick measure and then easily modify it. In this example, he uses the concatenated list of values quick measure in Power BI Desktop.
Marco Russo joins Patrick to discuss how to hide future dates for calculations in DAX. Marco walks through Power BI Desktop with some examples that work and don't work. SQLBI Article: Hiding future dates for calculations in DAX