When working with graphical objects in MS Office applications there is often a need to integrate multiple objects within one group so that we can move and manage them more easily. As of August 2019, Power BI Desktop has the option to group two or more objects, and in the text that follows you will be able to see how it is used.
When we use Excel to create a diagram, we add a few shapes that we later link with arrows to illustrate the flow of the process. All graphic objects can be aligned manually, by dragging them and matching the position with respect to another object. However, all this can be done much easier with the object editing options, where we can still position, group, ungroup objects …
Pivot tables have built-in options for applying autofilter to display data relative to rows, columns, and filters. By opening the autofilter menu, data sorting can be performed according to the specified reporting dimension, or it can narrow down the set of displayed values in the table by setting the conditions that relate to the description or value of the data displayed in the report. More about filtering Pivot tables can be found in the text that follows …
When we work with large tables containing the subtotals according to categories (article classification, sales program, type of partner, etc.), we can perform a grouping by to one of the given criteria. Grouping can be done by rows or columns, and the goal is to make the report more transparent. That is, if necessary, we can display or hide the analytical elements of the report in order for the data to take up less space.