Category: Data Modeling

Use DAX To Segment & Group Data In Power BI

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,

Continue reading

Find Out How To Quickly Create Virtual Groups In Power BI

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

Continue reading

Using Dynamic Visuals On Ranking Based Parameters In Power BI

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

Continue reading

How To Harvest Power BI Slicer Selections To Use Within Other Measures

How To Harvest Power BI Slicer Selections To Use Within Other Measures

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

Continue reading