When defining conditional formatting rules, sometimes there are more than one format, and we want one formatting rule to exclude another. In these situations, Stop If True option may be helpful. It is used in various ways, and one of the simplest is filtering the conditional formatting rules given by icon sets. Let’s see how this works!
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.