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
In this tutorial, we’re going to learn how to unpivot columns in Power BI, and understand the importance of doing it inside our data models. When working on data inside Power BI, we generally want it to be in an unpivoted format. This is the most optimized way a table can be set up for
There are many occasions where you may bring data into Power BI and the data structure is not optimized for your data model. In this article, I’m going to work through when you should utilize the unpivot or pivot feature in the Query Editor within your data queries. One thing to bear in mind early
