Power BI groups

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“ …

Filtering of PowerBI reports

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.

PowerBI workspace

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.

Power BI Desktop, drilldown

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.

Chart analytics

Right below the menu with visualization tools there is a set of three icons that allows us to enter one of the three menus that will be shown at the bottom of this panel. They are called Fields, Formats, and Analytics. First shows all the fields that affect appearance of a visual, second has options for its formatting and the third contains functionalities by which we can improve the chart: trend line, constant, minimum, maximum, average and forecast …