This article will briefly talk about integrating scenarios into our models. We can do that by using the Power BI What If Parameter feature. We can add this parameter to our reports as slicers or reference them on DAX expressions. Integrating a What If Parameter into our reports enables us to create scenarios or predictive
In this post, I’d like to continue presenting the Power BI best practice when developing reports. As I mentioned last time in part one of this series, I have consumed many online resources which have been instrumental in my own journey; but I quickly became overwhelmed by all the content. I ended up making my
In this tutorial, you’ll learn how to handle missing data in a currency-rates table using DAX and power query. You’ll learn the different ways to manage the missing rates in your table and present them effectively in a dashboard in Power BI. You can watch the full video of this tutorial at the bottom of
In this tutorial, I’ll demonstrate how you can create 2 split percentages in a donut chart using DAX calculation groups while avoiding having to unpivot data in Power Query. You can watch the full video of this tutorial at the bottom of this blog. This actually came from a question raised by one of our
