Ribbon is a new visualization that has recently become part of the Power BI reporting platform. When is it used? If you want to show some indicators, for example sales revenue or total costs in relation to time, you will use either a Line or Column chart. If you hesitate between these two visualizations, you can use Ribbon, which represents the best of both!
Calculation groups is a new option within the Power BI Desktop application that allows us to implement DAX calculation groups within the data model. They serve to simplify calculations when we use similar DAX expressions, where only the variable (expression) that appears in them varies. By adding them, the model is automatically optimized by removing implicit measures.
When making reports, users often create measures using complex DAX expressions. Because of this, they often use some external tools to prepare and analyze the created measures. For this reason, the Power BI development team added, in addition to the three existing ones, one more view within the Power BI Desktop application. It enables the creation and analysis of complex DAX measures.
You have probably noticed that in Power BI service Datasets have recently been replaced by Semantic Models. Model Explorer is a new feature of Power BI Desktop. It is located in the Model view, and enables views and work with complex semantic models that contain tables, relations, measures, roles, calculation groups, cultures, perspectives…
Imagine this scenario: you register customers in an Excel spreadsheet, specifying their ID and then the products they use. Which customer uses which products? One way to get this answer is to create a pivot table, and then display customers, products and the number of products. The disadvantage of this report is that pivot tables always aggregate data. What if we only need a table with customer ID in one column and a consolidated list of products in another?