Using DAX measures to dynamically group data in Power BI is so powerful. You’re building out your data models and creating many different filters and ways to slice your data. This is slightly more advanced today, but I love this type of stuff in Power BI. Remember, these likely don’t exist in your original datasets,
Did you know there is a way to create groups virtually in Power BI? I was so happy when I discovered this, as it allows you to quickly and effectively create another grouping dimension in your data sets or data tables. The Power BI team has made it so easy to implement and edit as
Through this example I’m going to show you how you can dynamically adjust the size of your visual. And in this case, we’re going to do it via the result ranking in Power BI. We’re going to create dynamic visuals containing our top 10 customers for specific products. This is a really powerful technique that
What I’m looking to achieved here is to showcase how you can create a table on the fly in Power BI, then place a column of that table into a slicer to then extract or ‘harvest’ a value inside a measure. Then be able to insert this into an existing calculation or another measure that
