Button appearance

Buttons in Power BI reports are used to navigate between different pages of the report, so in addition to the functional aspect, it is important that they look nice. When you add a blank button, Power BI Desktop provides many options for formatting its appearance. Since recently it is possible to add images that will represent a button, and also to select different images for different states (default, mouse over, click etc.)

Slicer navigation

Power BI Desktop has been supporting buttons for some time which make it easy to navigate between multiple pages within a Power BI report. Until now, the button could only lead to one given destination (page) and now, by combining the button and the slicer, it is possible to provide a selection of the page with the report you want to look where you further go by clicking on the button. In this way slicers become main tool for navigation.

Power BI row-level security

Companies often have the need to restrict certain employees or groups from seeing part of their business data. Power BI solves this by using Roles and defining the rights at the leven of Workspace in which they work. In practice, this means that everyone sees exactly what they are allowed to see. Nothing more, nothing less! In the following text you will see how Power BI row-level security is being implemented …

Excel and Power BI

In an old cartoon was promoted a saying: “Cats and mice can be friends”. Consequently, Excel and Power BI can also be friends! Power BI allows you to import Excel reports, whether traditional, Pivot or Power Pivot reports. This is not a whole new topic, but I think it would be nice to remember it in a new light, with an emphasis on what you can do for free and when you definitely have to buy licenses.

Data categories

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.