A sales manager at one of my clients had a five-page Power BI report. She’d pick 2025 and the East region on the first page, open the second page, and see every year and every region again. She had to make the same picks on every page, and after a week she stopped using the … Read more >>>
A regional manager asked me for a sales page where the chart title says which regions they picked, and a second slicer to switch the chart between revenue, cost and profit. Both requests come down to the same skill: reading what’s selected in a slicer and using it in a measure. In this tutorial, I’ll … Read more >>>
A sales manager once asked me why two reports showed a different number of sales for the same month. One report used COUNT(Sales[Sales Id]), the other DISTINCTCOUNT(Sales[Sales Id]), and some orders had been split into several rows with the same ID. Both numbers were correct; they were just answering different questions. DAX has eight functions … Read more >>>
A regional sales director once asked me why the “average sale” in their Power BI report didn’t match the number their finance team calculated in Excel. Both were right. Power BI was averaging individual transactions; finance was averaging monthly totals. The fix was one line of DAX: switching from AVERAGE to AVERAGEX. DAX has three … Read more >>>
![Power BI formula bar with Discounted Large Orders = CALCULATE(COUNTROWS(SalesData), SalesData[Quantity] > 10, SalesData[Discount] > 0) and a table of count measures by Region](https://www.enjoysharepoint.com/wp-content/uploads/2026/10/power-bi-countifs-calculate-two-conditions-formula.png "power bi countifs calculate two conditions formula")
Excel users moving to Power BI almost always ask me the same thing first: where’s COUNTIF? A sales manager wanted the number of orders over 10 units, per region, updating with every slicer, and typing =COUNTIF in Power BI got them nowhere. Power BI has no COUNTIF function, but DAX does the same job with … Read more >>>
When a Power BI matrix squeezes long product names into a narrow column or stretches a short number across half the visual, you need to control the column width yourself. Power BI sizes matrix columns automatically by default, so the first step is turning that off. Power BI Desktop has an “auto-size column width” feature … Read more >>>
A waterfall chart usually ends with an automatic total, but often you also need a starting total, such as last year’s revenue on the left, or a subtotal in the middle. In this tutorial, I’ll show you how to set a bar as a total in a Power BI waterfall chart, move or remove the … Read more >>>
Power BI still has no rounded corners setting for the bars themselves. I checked again in Power BI Desktop in October 2026: Format visual > Effects > Visual border > Rounded corners only rounds the visual’s outer border. You can still give a bar chart rounded ends without a custom visual by using error bars, … Read more >>>
In a recent sales report, some products had no sales in a region, so their bars simply disappeared from the bar chart instead of showing zero. The data had blank cells, not zeros, and Power BI skips blanks. Here’s how to show zero values in a Power BI bar chart, and how to hide them … Read more >>>
A Power BI line chart with a missing month doesn’t drop to zero; it draws a straight line across the gap, which makes a bad month look normal. In this tutorial, I’ll show you how to make the line chart show zero values when there’s no data, and how to hide zeros when you don’t … 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