Personal Teams Report in Power BI | Teams Nation Give away
During Teams Nation in May 2021 I had the great honor of talking in the Adoption room in regards to how Power BI could be used to drive Adoption of Microsoft Teams. It had a twist though! Instead of using the insight in a Power BI report, I talked...
Sick Leave – PowerApp give away
Some time ago, me and my colleagues did a hackaton in the Power Platform, building an App in PowerApps to handle sick leave. The idea is simple. You find yourself suboptimal, as Nathan W Pyle would have put it, and it’s time to inform your colleagues of your absences...
Soft value calculation – Coffee complaining
Ancient business Mythology tells a legend of a CFO who once asked: "What if we invest in our employees and they leave us" to which the CEO responded "What if we don't and they stay?". Read this blog about how all this relate to coffee....
Colorful threshold in an Area Chart
The other day I though about KPI’s, as a totally normal person would. I think. Anyhow, my mind drifted of to area charts and how it would be neat to set a threshold and change the color when you passed a certain line! When I got back to my...
Power BI – Using What-if dates
I recently built a price development function inside a Power BI report for a customer by using What-If parameters. To be fair, I usually don’t add what-if parameters in my reports since they tend to have enough data and available columns for slicers as it is! Adding possible outcomes...
Teams Attendee report in Power BI
Want to skip reading and just download the template and get started? Click here to download the PBIT-file! For a while (and given your admin has made some PowerShell-magic), we’ve had Attendance report (not just Attendance List, available to download while still in the meeting). With this, you can...
Sweden’s population in Power BI
I recently got my hands on some open data from the Swedish bureau of statistics (SCB). Anyone could download this from their site but apparently, not everyone is interested in spending Saturday evenings building Power BI reports (yes, I am about as confused as you are!) and since the...
Streaming datasets in Power BI
I usually try to add three perspectives in my Power BI Reports. Three aspects I find that Power BI is really god at visualising: KPI Trends Details I will go into details on this in future posts, but for now let’s just say that these three pillars are mainly...
Behind the scenes of The Power Challenge
I recently set up the Microsoft Team for the Power Challenge for the contestants to enter as guests before the challenge begins. For any new member who registers on the site above, a flow is triggering an Azure Automation that adds you as a guest to the tenant and...
Merging Cells in Excel lists
Lets say we have this list of people. We know who their managers are and we know whether they like Excel or not. (All users in this blog has given consent under GDPR to have their personal view on Excel processed). Let’s say we want to send out an...