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

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

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…