With the February and March 2023 Desktop releases comes more features enabling us to enhance our KPI visualisations out of the box. This article talks specifically to the DAX function LINEST() and the new Subtitle and Dividers formatting options. For a simple enhancement, we can add the divider to KPI Cards, without title and subtitle,… Continue reading KPI trend indicators on Core Visuals

Precisely-Timed Measurements vs. Imprecisely-Timed Events: How Do We Correlate/Relate Them? The Streak is Broken… and a new streak begin

Dear all, I’m new in power BI and I have a problem for calculating a weighted average based on a total of a column. In attach a simplified example for my PBIX. As you can see I have two table, a master table and a summarize table, with few fields calculated from master table. On summarized table I h...

This article describes a counterintuitive behavior of BLANK in DAX measures affecting Power BI, Analysis Services, and Power Pivot. That behavior could caus

Use stats functions in Power BI to calculate the daily average sales for any given date range.

bring the awesome to moving averages with text formulas for slicer and title— and yes, a Greatest Formula In the World (GFITW) version for custom calendars

Histograms require some statistical knowledge to grasp, and without the tidbits, the distribution chart looks like any other bar chart. So much more though. They can show a lot about your data, and…

HI, im trying to get the STDev of a sumarized table, I tried the measure in the photo, It gives me the number Im looking for, but I cant display it in the Graph. I need to apply filters on it, thats why I cant create a real table.   PD: The real table is in the right side.

Hello guys,   I wanted to calculate the median in Power BI. We have a lot of rows full of data about the days we needed for a repair. In a different column we have listed in which workshop the repair was done and what kind of repair it was. So in Power BI Desktop I filtered one workshop and showed i...

Please note the performance is not optimized for a very large dataset, try with your own data. Create a Median Meausre [Lowerbound] =MINX( FILTER( VALUES( BoxOffice[TicketsSold]), CALCULATE( COUNTROWS( BoxOffice ), BoxOffice[TicketsSold] = COUNTROWS( BoxOffice ) / 2 ), BoxOffice[TicketsSold]) [Upperbound]=MINX( FILTER( VALUES( BoxOffice[TicketsSold]), CALCULATE( COUNTROWS( BoxOffice ), BoxOffice[TicketsSold]

When analyzing data, I often find myself computing the percentile value. As I am a big fan of PowerPivot , I went w...

Building from my last post, Performance Metrics: Average, Mean, Median, and Outliers, where I covered the topic of when to use Median instead of Average, in this post I’m going (to try) to sh…

Last month, I explored how to take a Power BI area chart and make it into a unique “new” chart type using only data and DAX formulas. The line chart is also a candidate for a bit more f…

As Buck Woody notes here, when you are exploring a new data set it can be useful calculate some basic descriptive statistics. One new M function that appeared in Power BI recently can help you to d…

Learn how to create a bell curve and histogram with the Power BI Desktop.

Learn about the mathematical formulas available in the Power BI Desktop and Power Query as well as how to load and convert data for your reporting needs.