Recently, I have designed a Power BI report with different visualizations. To filter the values on the report, I added a Slicer visual to it. If the Slicer consists of too many items, such as Project Names or Product names, etc., this helps to filter the values. It will take time to find the specific … Read more >>>
Learn how to edit visual interactions in Power BI. Set Filter, Highlight, or None, change the default to cross-filter, and fix common issues. Free Excel file.
Merge vs Append in Power BI explained: learn the key differences, all 6 join kinds, fuzzy matching, and exactly when to use each, with step-by-step examples.
When I build reports for clients, the data almost never comes in one clean table. Sales sit in one file, product details in another, and region information lives in a SharePoint list. To report on all of it together, I need to merge tables in Power BI. In this tutorial, I’ll show you exactly how … Read more >>>
A colleague had a SharePoint list where people typed the manager’s name as plain text, and his flow needed to email that manager. Names are easy for people and useless for email, so the flow first had to turn “Megan Bowen” into megan@contoso.com. In this tutorial, I’ll show you how to get an email address … Read more >>>
“I changed the page, but users still see the old version.” “My new name doesn’t show in SharePoint.” “The file won’t sync.” When I hear these, the problem is often a cache: something on the user’s PC is holding on to an old copy instead of fetching the new one from SharePoint. In this tutorial, … Read more >>>
Collections are where I keep temporary data in a canvas app: a shopping cart, the items a user checked in a gallery, or rows I’m about to save. Sooner or later, you need to take things out again, one item, a few that match a condition, or everything. In this tutorial, I’ll show you nine … Read more >>>
On a client’s intranet home page, HR wanted employees to leave feedback without opening another app. The Microsoft Forms web part solved it: the form sits right on the SharePoint page, and responses go to Microsoft Forms like any other form. In this tutorial, I’ll show you how to add the web part, create a … Read more >>>
A plain text box is fine for a name or a number, but not for an announcement, a meeting note or a product description. Users want bold text, bullet points and links. The Rich text editor control gives your canvas app a small word processor, and it saves the result as HTML. In this tutorial, … Read more >>>
An HR team I worked with ran employee training registrations through Microsoft Forms. Every new registration had to get the next number in a SharePoint list: 1, 2, 3 and so on. SharePoint’s own ID column wasn’t an option, because they wanted their own sequence that they could reset each year. In this tutorial, I’ll … 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