I want to spend some time today going through a question from Enterprise DNA member, Lucas about table visual in Power BI. It’s an interesting question in of itself, but I want to dissect it because it also touches on a bunch of other interesting topics, including disconnected tables, slicer harvesting, and some slicer visualization
I want to go over a Power BI dynamic grouping technique. I’ll show you how to dynamically showcase segments of your bands of information. This is a powerful technique to build upon your data model. You can watch the full video of this tutorial at the bottom of this blog. I have a really simple
In this tutorial, you’re going to learn the complex measures and DAX formula used to create an inventory management dashboard in Power BI. As a seller, you have to know how many products you need to re-order and stock and how much these will cost you. Use these DAX formula patterns to get those calculations
In this tutorial, I’ll show you some advanced formulas and DAX examples using different functions in Power BI. Some of the functions that you’ll encounter in the examples below are CALCULATE, FILTER, MAX, ALLSELECTED, and many more. But before you begin, make sure to optimize your measures. I always recommend using measure groups to make
I want to introduce you to a group of functions in Power BI called table functions. These functions include FILTER and ALL which we already used or mentioned in other topics. There is a whole range of other table functions which includes functions like VALUES, TOPN, and ADDCOLUMNS. However, we are not going to cover
