The most recently updated SharePoint, Power Apps, Power Automate and Power BI tutorials from EnjoySharePoint. Every tutorial is tested in a real Microsoft 365 tenant.
You probably already have your data in Excel. With Power BI, you can turn that spreadsheet into an interactive report that refreshes itself, without learning to code. This guide walks you through building a Power BI report from Excel, from preparing the file to publishing a report that updates when your spreadsheet changes. Quick Answer: … Read more >>>
A few days ago, a client asked us to customize a SharePoint Site Page that displays lists, libraries, list views, and recent documents related to the Task Management system. To make the SharePoint site page visually more attractive and enhance the appearance of lists and libraries, I have added column formatting to the SharePoint list … Read more >>>
When a sales director asks “which products sell the most?”, I answer with a bar chart. Long product names fit on the axis, the ranking is obvious at a glance, and it’s the chart people read correctly without any explanation. In this tutorial, I’ll show you how to create a bar chart in Power BI, … Read more >>>
A sales manager asked me for a chart showing how revenue splits across our four US regions. I added a pie chart, and a colleague said a donut chart would “look more modern.” That turned into a real donut chart vs pie chart question: in Power BI, is a donut just a pie with a … Read more >>>
Most of the Power BI reports I build for sales teams have one pie chart, usually showing how revenue splits across products or regions. It’s often the first visual a manager looks at, so it needs to be readable at a glance, and the defaults rarely get it there. In this tutorial, I’ll show you … Read more >>>
You build a flow, pull some data from a SharePoint list or Excel file, and everything looks fine… until you try to add two numbers and your result is 1020 instead of 30. The value is coming in as a string (text), not a number, and suddenly your calculations, conditions, and approvals start behaving in … Read more >>>
When I build a Power BI report, I almost always need a highest or lowest value somewhere: the latest order date, the best test score, the shortest delivery time, or the top sale for one product. DAX has six functions for this, and picking the right one saves a lot of head-scratching. In this tutorial, … Read more >>>
Our operations team wanted to know how long orders sat in the warehouse before shipping, which orders were still open, and how many shipped after their due date. Every one of those questions is a date difference, and in Power BI DATEDIFF answers most of them in one line. In this tutorial, I’ll show you … Read more >>>
Quantity times price, an amount times a tax rate, last year’s sales times a growth factor: some kind of multiplication shows up in almost every Power BI report I build. The operator itself is simple, but there’s one common mistake that quietly produces wrong totals, and I see it in reports all the time. In … Read more >>>
Date filters in Power BI trip up a lot of people, not because they’re complicated, but because there are several ways to do the same thing, and picking the wrong one creates unnecessary headaches. In this tutorial, we will see how to filter dates in Power BI using every practical approach: from the simple relative … Read more >>>
122 copy-paste formulas with real examples, sent straight to your inbox.
Your free Power Automate Expressions Cheat Sheet is on its way. Can't find it in a few minutes? Look in your Promotions or Spam folder.
Sent to