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.
In this Power BI article, I will explain what is a Power BI Waterfall chart and when we can use a waterfall chart in Power BI. Additionally, we will discuss how to create a waterfall chart in Power BI using an Excel sheet as well as a SharePoint list. Power BI Waterfall Chart When to … Read more >>>
A Power BI stacked column chart shows one column per category, split into colored segments that add up to the column’s total. To create one, select Stacked column chart in the Visualizations pane, then add a category to X-axis, a number to Y-axis and a second category to Legend. Last month, the sales manager at … Read more >>>
I have created a Power BI report based on ‘Product Sales Information‘ for one client, utilizing various types of visualizations. On that report, the client instructed me to display the average sales amount of products in the matrix visual. However, by default, the matrix visual displays a sum aggregation of the values, showing the total … Read more >>>
If you’re looking for the Stepped layout switch in a Power BI matrix and can’t find it, you’re not missing anything: Microsoft replaced it with a Layout option. I ran into this when a client wanted their matrix to look like a flat Excel table, with each row field in its own column. Quick answer: … Read more >>>
A finance manager who didn’t have a Power BI license asked me for the numbers behind one of my report visuals so they could add their own calculations in Excel. Power BI can do that in a few clicks, but what you get depends on where you export from, which option you pick and how … Read more >>>
Recently, while working on a Power BI Report with 30+ measures, I found it challenging to track which measures belong to which table. To address this, Microsoft Power BI provides a solution by creating a table for better organization. In this Power BI tutorial, we will explore the concept of a Power BI measure table … Read more >>>
A sales director asked me for a summary table with total revenue next to West revenue, Q1 revenue and furniture revenue, plus a product list that only shows products above a minimum the user picks. Every one of those columns is the same Revenue measure with a different filter applied. In this tutorial, I’ll show … Read more >>>
In this Power bi tutorial, we will learn about power bi measure subtract with example. And also we will discuss the below points: Power bi measure subtract two columns Power bi measure subtract dates Power bi measure subtract two columns with different tables Power bi measure subtract two measure Power bi measure today minus date … Read more >>>
In this Power bi tutorial, we will discuss everything on power bi measure by category with different examples. And also we will discuss the below points: Power bi measure by category Power bi measure sum by category Power bi measure count by category Power bi measure per category Power bi measure percentage of category Power … Read more >>>
In this Power BI Tutorial, we will learn about Power BI Measure SUM. Also, we will discuss: Power BI Measure sum Power BI Measure sum multiple columns Power BI Measure sum multiple measure Power BI Measure sum date Power BI Measure sum if column contains Power BI Measure sum IF Power BI Measure sum with … 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