In today’s blog, we will demonstrate a handy feature inside a Power BI—the combination of field parameters and small multiples. There are indeed a lot of automation and productivity tools in Power BI, but when we layer this technique into them, we can create even more incredible insights and visuals. You can watch the full video
Tag: Data Modeling
As you progress in Power BI, you will gradually be working with more DAX measures and calculations, and things can easily get cluttered. For today’s tutorial, I will share a few data modeling techniques on how to organize your DAX measures better for a more efficient workflow. You can watch the full video of this tutorial at
In this blog post, we’ll talk about the difference between Conditional and Custom Columns in Power BI. We’ll also show examples of when and how we can use them, including some of their alternatives. Custom columns require a different formula language that we need to learn first. On the other hand, conditional columns are easy
In this tutorial, we’ll discuss how we can create and use Power BI Parameters which is a powerful feature of the Query Editor. There are instances when we want to put additional filters on our data within the query editor. We can do that by utilizing the Manage Parameters option within the Home ribbon. For this
When doing an analysis on our model, we might want to find an insight that’s unrelated to anything within our tables. That’s where the concept of using supporting tables for Power BI data modeling comes in. Supporting tables don’t have any relationship with our tables, but we can use them to support the visualizations in