Another question from the comments… MrTavelBlog wanted to know how to show 5 minute intervals in Power BI. Patrick accepts the challenge and shows you how!
Power BI date table: create using DAX
https://www.youtube.com/watch?v=gyvhM5eiT0U
Working with time in Power Continue reading “How to show 5 minute intervals in Power BI?”
You need a connector to work with data in Power Query for Power BI or Excel. But what is a connector? Adam explains what these are and how to find out what’s available.
Power Query Connectors:
https://docs.microsoft.com/power-query/connectors/
Power BI data Continue reading “What are Power BI data connectors and why should you care?”
Download Excel File: https://excelisfun.net/files/Ch03-ESA.xlsm
Learn about what the geometric mean is and how to use it. Great Historical Microsoft Stock Price Example.
Topics:
1. (00:00) Introduction
2. (00:37) Define Geometric Mean
3. (01:09) Look at variable in the formulas for calculating Geometric Continue reading “Excel Statistical Analysis 11: Geometric Mean to Calculate Average Compounding Rate per Period”
Have you struggled with using Row-Level Security (RLS) on a dimension connected to two fact tables? Patrick looks at some options you can use to accomplish this in Power BI.
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take Continue reading “RLS with TWO Fact tables in Power BI”
We talk about optimizations a LOT! We pile onto a question posed by Chris Webb – Should you optimize for CPU in Power BI? We think the answer is YES! Let’s explain…
Chris Webb’s Blog:
https://blog.crossjoin.co.uk/2021/09/19/why-you-should-optimise-your-power-bi-premium-reports-and-refreshes-for-cpu-time-as-well-as-duration/
3 signs it’s time Continue reading “When optimizing Power BI don’t forgot about CPU”
You may have struggled getting a whole row to highlight in a Power BI report. Patrick shows you how you could do this with a Paginated report easily.
Paginated Samples:
https://github.com/microsoft/Reporting-Services
📢 Become a member: https://guyinacu.be/membership
*******************
Want Continue reading “Highlight a row in a Power BI Paginated report”
Struggling with understanding what is filtering your visual or Power BI report? Patrick walks you through how you can tell what is going on.
SQLBI Filter Context: https://www.sqlbi.com/articles/displaying-filter-context-in-power-bi-tooltips/
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take Continue reading “What’s this Power BI report filtered by???”
There has been a lot of recent news about Power BI Premium. Adam looks at what Gen2 is all about along with timelines to keep in mind. A MUST watch… probably.
What is Power BI Premium Gen2:
https://docs.microsoft.com/power-bi/admin/service-premium-gen2-what-is
Power BI Continue reading “The Power BI Premium video you need to watch… probably (Oct 2021)”
Wondering how Patrick created a popup video in a previous video? Well, here you go! Learn how you can create a popup experience to provide more information in your Power BI report.
Bookmarks Playlist:
https://www.youtube.com/playlist?list=PLv2BtOtLblH1IJqcqSuMTyvEi7W-laWti
📢 Become a member: <a Continue reading “Create a Popup Window in Power BI”
Do you analyze performance of your Power BI report? You SHOULD! Why the heck does Adam start with a blank page? Find out in this video!
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills Continue reading “Page intentionally left blank”
Calculating Days since a given date in DAX is pretty straight forward. But, what if you want flexibility with different dates in your model? Patrick shows you how to do that with Power BI.
📢 Become a member: rel=”nofollow”>https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com
***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/
#PowerBI #DAX #GuyInACube
You should be reviewing performance of your Power BI Reports. This report from Smart Power BI helps you to visualize the results of Performance Analyzer. Let’s check it out!
Performance Analyzer Documentation:
https://docs.microsoft.com/power-bi/create-reports/desktop-performance-analyzer
ADVANCED POWER BI PERFORMANCE ANALYSER BY SMARTPOWERBI
<a Continue reading “Review Performance Analyzer in this Power BI Report from Smart Power BI”