Santa Loves Power BI and R
This past week I was talking with the big guy up north, jolly old fella, and the discussion came up about his toy production levels. […]
DAX Expressions
Measures – Year Over Year Percent Change
This tutorial is a variation on the month to month percent change tutorial. This specific exploration in year over year performance was born out of […]
Pareto Charting in PowerBI
The Pareto chart is a handy visual, but is not so easy to build in either excel or PowerBI. In a Pareto chart, information is […]
Map with Data Labels in R
Mapping is one of the better features of PowerBI. It is one of the more distinguishing feature differences between Excel and PowerBI. You can produce […]
Fixing Measure Madness
Often times when you’re working with large data models you will have multiple tables with many relationships. It could be complex maybe you’ve seen something […]
Digging Deeper with R Visuals for PowerBI
Back by popular demand, we have another great tutorial on using R visuals. There are a number of amazing visuals that have been supplied with […]
Measures – Intelligent Card Visual – Using DAX
As I have been exploring PowerBI and building dashboards I have noticed that often the visuals can obscure your data. As you click on different […]
Measures – Month to Month Percent Change
I had an interesting comment come up in conversation about how to calculate a percent change within a time series data set. For this instance […]
Measures – Dynamic Percent Change – Using DAX
This tutorial will produce a measure that will dynamically calculate a percent change every time an item is selected in a visual. The previous tutorial […]
Measures – Dynamic CAGR Calculation in DAX
This tutorial walks through calculating a dynamic Compound Annual Growth Rate (CAGR). By dynamic we mean as you select different items on a bar chart […]