The Pivot cache is automatically created each time you insert a Pivot table, and it is an object that replicates the data source based on which Pivot table is being made. Each time you need to change the look of the Pivot table, Excel automatically calls the cache, simply because it’s much faster – it handles local data, stored in the computer’s memory. However, what happens when a synchronization error occurs?
Power BI service, in accordance to trends, allows document sharing and collaborative work. There are multiple file sharing mechanisms, and most of them are only available to users of the Power BI Pro license, which is understandable because sharing involves working in a group, it makes no sense to share something with itself. In the following text I’ll mention address workspaces and further document sharing, how to generate QR code and monitor report statistics.
Drillthrough is an option that allows one or more reports, extracted on a separate report page, to be obtained based on the chosen dimension according to which we want to display its details. In this way, PowerBI reports get on interactivity, and by using this feature one complex report can be divided into several smaller and simpler ones, making it easier to find the information requested.
Appearance of the report is no longer only important thing, but also its interactivity. Therefore, new feature – buttons are added to PowerBI. These are graphic objects intended to give you a step backward, if you drilldown within the report, to launch a report that is recorded as a Bookmark or display a table/chart that was created as a result of a pre-designed question.
Slicers are great feature, but unfortunately they can not be used to filter traditional Excel reports. If we use the conditional aggregation functions, in order to calculate the desired values, as well as the data validation technique, we can make simple but effective filters by selecting the values from the list. By selecting the criteria from the list, the automatic update of the values in the report is performed. Let’s see how this works!