Adriatic BI company specialized in
PowerBI / PowerApps / Excel
20+ international and domestic clients
Implementation and Education!
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...Read more
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,...Read more
In this article, we will show you the way to track changes you make in your table by using Power Query. The presumption is that we have one table that serves as a database (HistoryData). Then we have a new table which has the same structure as the first one,...Read more
Sometimes in the Fact table, we can have packs with multiple products included. In this blog, we will show how to split those packs into individual products and how to assign correct sales values and quantities to each individual product within the pack. The problem The Fact table contains multiple...Read more
Microsoft certificate for being experts in BI reporting.
With modern Microsoft tools for data manipulation and analysis (PowerQuery, DAX).
of experience working with the PowerBI environment.