Finally!!! We Can Now Format The Same Measure as % OR $ on the Same Trend Chart (calculation groups bug is fixed!)

I knew this moment would come, but I did not know when. We are now able to have a smart measure that can be displayed as any valid number format on our chart, $$ or %, or even whole dollars All it took was for me to raise a bug with Microsoft about the formatting … Continue reading Finally!!! We Can Now Format The Same Measure as % OR $ on the Same Trend Chart (calculation groups bug is fixed!)

Improve Slice and Dice End User Experience for Tables with Multiple Dates (tutorial)

Slice and Dice experience on a table with multiple dates can be a little frustrating. If I have two date tables connected to my two date columns in the transaction table (so if I have a list of projects, Project Start Date and Project End Date), and if I create two filters at the same … Continue reading Improve Slice and Dice End User Experience for Tables with Multiple Dates (tutorial)

Power BI DAX Tutorial: How to PIVOT Data Using DAX (using RANK.EQ function)

Little known fact, I used to box, and boxed a lot… Unfortunately, it did little to help me with my public speaking as you will definitely be able to see from this video where I constantly say UNPIVOT instead of PIVOT. My apologies, hopefully, you will be able to enjoy the video anyway as the … Continue reading Power BI DAX Tutorial: How to PIVOT Data Using DAX (using RANK.EQ function)

Tutorial: How to Calculate an Average of the Best using AVERAGEX() and ADDCOLUMNS() Functions

This is a fun tutorial where we will learn how to calculate average of the highest values that might be spread across different time periods. A good example is figuring out what would be a good proxy for the highest temperature for IL in July. If we simply take one reading for the highest day … Continue reading Tutorial: How to Calculate an Average of the Best using AVERAGEX() and ADDCOLUMNS() Functions

Getting Better at DAX: Having Fun with Running Totals

This is a fun little tutorial that will give you another chance to practice you CALCULATE() and FILTER() functions skills. Running totals are a common problem that we have to deal with. To illustrate this problem, I created a sales dataset for innovation products. In our example, after the product reaches $1m in global sales … Continue reading Getting Better at DAX: Having Fun with Running Totals

How to Stay Current with Power BI Updates and Roadmap

In this video I cover several official sources from Microsoft for staying current with Power BI updates and road map. The important links are below. https://youtu.be/YVcATKT0Ygs Roadmap: 2020 Release Wave 1 Plan: https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/ 2020 Release Wave 2 Plan: https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave2/ PDFs: Wave 1: https://go.microsoft.com/fwlink/?linkid=2116925 Wave 2: https://go.microsoft.com/fwlink/?linkid=2134934 Ideas: https://ideas.powerbi.com/ Power BI Blog: https://powerbi.microsoft.com/en-us/blog/