Last year brought us another interesting Power BI Desktop feature. When importing tables into a data model, it is possible to specify a data category for the selected columns. Choosing a category can accurately determine what data is in the table. This way we get some new features, e.g. to include a link to a site or an image describing the products within the table.
Power BI Desktop got updated ribbons! The new, modern design, simplifies operation significantly because options are better grouped and easier to find. It is very similar to the one we encountered in Office365 applications and appeared as one of the preview features in November 2019. From April 2020, this should become the default look of the Power BI Desktop development environment, let’s see what new it brings.
When you create a Pivot table report there are several options that you can use to influence its appearance. These can be some of the settings in the Options menu, and you can also change the Report Layout by selecting from the menu located in the Design ribbon. What’s new in Excel 2019 is that you can now set the default Pivot table report layout so that each new report looks the way you want it …
When we add dimensions to the Pivot table, columns in the report are filled in sequentially. If we use a different report layout than the Compact View, each report dimension will occupy one column, and then all columns in which the data aggregation is performed will be displayed. There is one setting within the pivot table options that allows us to differentiate values (the data we aggregate) from reporting dimensions.
The end of the old and the beginning of the new year is often a reason to look back. I read this post a while ago and it seems that I could have clarified one of the things better. There are many different views on pivot tables, and as Nectar’s advertising slogan says, “It does matter” In this “recipe” we will deal with each of them, after which you can decide for yourself when to apply which view to get a suitable report.