We wish Power BI had dynamic legends based on selections! Well, Patrick took the challenge and here is a way you can do just that! Shout out to Parker Stevens, at BI Elite, for getting us started on this.
BI Elite Continue reading “Do you want DYNAMIC legends in Power BI??? Of course you do…”
Join us live as we answer your questions about Power BI! With special guest, Matthew Roche!
Connect with Matthew:
Twitter: https://twitter.com/SQLAllFather
YouTube: https://www.youtube.com/channel/UCpsilPn-2qFlrYYuvyFkpPQ
Website: https://ssbipolar.com/
💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public Continue reading “🔴 Closing out 2021 – LIVE w/ Matthew Roche (Dec 18, 2021)”
You’ve heard about Microsoft Dataverse but haven’t used it? Want to know more about it and how it relates to Power BI? Scott Sewell from the Power BI CAT team is here to help!
Connect with Scott:
Twitter: https://twitter.com/scottsewell
LinkedIn: Continue reading “Dataverse + Power BI: What you didn’t even know you needed!”
Ever run into a Parameter error when trying to refresh a partition in Power BI? It can drive you BANANAS! Patrick explains how to get around it and refresh successfully.
📢 Become a member: https://guyinacu.be/membership
*******************
Want to Continue reading “Avoid Parameter Error when refreshing a Power BI partition”
Did you know that there are two Dataflows connectors in Power BI? What’s the difference? Adam takes a look and explains what is going on.
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to Continue reading “Are you using the right Dataflows connector in Power BI???”
Tired of all those buttons for bookmarks in your Power BI reports? Patrick shows you how to use the Bookmark Navigator to easily get going and get rid of all those buttons!
Create page and button navigators
https://docs.microsoft.com/en-us/power-bi/create-reports/button-navigators
📢 Become Continue reading “Use Bookmark Navigator in Power BI to easily move through Bookmarks”
Already optimized your data model and still having some performance issues in Power BI? Check out Michael Kovalsky’s Report Analyzer tool to inspect your report.
Michael Kovalsky:
https://www.linkedin.com/in/michaelkovalsky/
Michael Kovalsky’s blog:
https://www.elegantbi.com/
Report Analyzer
https://www.elegantbi.com/post/reportanalyzer
📢 Become a Continue reading “Another Power BI optimization tool – Report Analyzer”
Sometimes your data isn’t shaped the right way. Have you tried the Pivot or Unpivot methods in Power Query? They can help get your data looking the right way for your Power BI reports!
Pivot columns
https://docs.microsoft.com/en-us/power-query/pivot-columns
Unpivot columns
<a href="https://docs.microsoft.com/en-us/power-query/unpivot-column" Continue reading “To Pivot or Unpivot? That is the question!”
Struggling ramping up on the Power BI Premium Gen2 Metrics App? Adam walks through the app to help you install it and navigate to get the most value. Some great stuff in the latest update!
Install the Gen2 metrics app
<a href="https://docs.microsoft.com/en-us/power-bi/admin/service-premium-install-gen2-app" Continue reading “Making sense of the Power BI Premium Gen2 Metrics App”
Thinking you don’t need a date table in Power BI? What about Fiscal month? Patrick shows how you could potentially go about adding that without a full date table.
But really, use a central date table 😎
Do you need a date Continue reading “No Calendar Table? How to add Fiscal Month and Sort in Power BI?”
Three ways to filter a pivot table and two of them you might not have known about. Daniel Bula asks if the trick from episode # 2359 can be used in a pivot table. Here is a great pivot table Continue reading “Excel Illegal Filter Hack – South Region Over $5K – 2372”
Do you need to randomly select someone from your department to win a prize? This awesome free macro from Rob Collie at PowerPivotPro.com will do the trick. Download for free from: http://mrx.cl/spinwheel20
Rob had an idea of Continue reading “Download a Free Excel Macro to Spin The Wheel – 2371”