This is the second part of the blog series dedicated to showing workarounds for currently unsupported matrix visual features. In the first part we explained how to add conditional formatting only for the specified columns, and in this article, we will explain how to introduce sorting. Below, you can test...

This is going to be the first of 2 articles explaining how to introduce conditional formatting and sorting when using calculation groups in Matrix visual. It would be great if conditional formatting and sorting could be applied to a calculation item, but until this happens, here is a workaround. Below,...

 In this article, we will see how we can use the self-referencing technique and Dataflows to create incremental refresh with PowerBI Pro version. This technique is tested and working both with cloud and on-premises data sources. In case you are using on-premise data sources to access new data, you need to...

When creating a budgeting prediction, most of the time we are creating it on the higher granularities. Rarely we do it on a daily basis. But sometimes we are required to match budgets to actual sales on lower granularities than the one we previously set (e.q. the manager wishes to...

High cardinality columns are often the problematic part of the data modeling in most environments, including PowerBI. Since the PowerBI data model resides on a columnar database, having high cardinality columns impact both performance and the size of the model. This is especially the case with columns having more than...

In this article, we will see how to combine different dimensions and facts inside a single matrix table visual. This approach helps us create fewer measures and tables, but at the same time, it provides us with greater design possibilities, like conditional formatting across the whole column even though there...