Programmers usually don’t care too much for report’s look, whilst those who watch the reports equally care for their clarity and appearance (correctness is assumed). PowerBI possesses several tools that can be used for enhancing reports. In my opinion it can still be much better. Nevertheless, from version to version PowerBI development team is adding new functionalities and now it is quite better comparing its beginning.
Power BI groups enable grouping of data within visuals for more efficient reporting. Depending on the type of dimension present in the visual (category or measure), it is possible to group parts of the report by default categories (Lists) or reporting segments (Bins). It is also possible to create groups of data and as well view a group which contains other series (Others). You will find out more about this in the following „recipe“ …
PowerBI reports can be filtered in a similar way as traditional Pivot or PowerPivot reports. Since one report is usually consisted of several visuals (tables, charts, cards, slicers) you could adjust a way that selected visual filters all other within a report that share same dataset. Also, you could filter a whole dataset by applying basic, advanced or Top n filters, which will be subject of a text that follows.
Workspace, as its name says, is used for the integration of data, reports and dashboards that is used in your daily work. The default workspace is called My Workspace and everything you create (datasets, reports, dashboards) is kept on this site, unless otherwise is specified. This post is word about how to create custom workspaces and use them to share content with other users. This functionality is enabled only in PowerBI Pro version.
Drilldown is a term that describes obtaining additional details of a report based on the selected reporting dimension. If you are an experienced Pivot table user you are most certainly aware of the technique. This operation can be also carried out over reports created within PowerBI Desktop environment. In text that follows, I will show you how to perform drilldown.