Editing report elements

Since March 2018, PowerBI Desktop has several new options for viewing and editing reports. First, there is an option to highlight one visual in relation to others, which is in its context menu. And then, there are a few more options that allow you to capture your favorite report views, view and manage objects in a report, lock objects, show field properties, and a set way to synchronize slicers…

Asking questions

Power BI users have long been able to, by entering a question in a specially specified field, create a report that, by combining the reporting dimensions and measures, answers the question asked. Recently this option has been enabled in the Power BI Desktop application. Home ribbon now, besides the usual „New Visual“ option, also contains „Ask a question“. Let’s see how it’s used!

Options for document recovery

PowerBI Desktop is an ever-evolving application. Although rarely, it may happen that it freezes, so you need to “kill” it by entering Task Manager, by pressing the CTRL + ALT + DEL key combination and exiting the active process. The novelty is that while working in the background, a document is being saved, so if a crash occurs, Power BI Desktop will offer you the option to restore the last version.

How much goods to order?

Most traders order intuitively, which is perfectly fine when dealing with small quantities of goods. When sales rises, in order to be efficiently ordered, insight in inventory costs is needed. These costs are divided into three groups: costs of acquisition, holding and lack of inventory (missed income due to lack of inventory). An economically justified order quantity is the one that causes the lowest inventory costs.

Refilling shelves

I often get upset when I go to the supermarket and see the workers closing the passages by racking up the shelves. How to help them? If a company has implemented an ERP, it is possible to extract a stock report, critical inventory, and a place where the items are located (warehouse, location, position). With a little imagination and knowledge of conditional formatting techniques, there is an easy way to mark those shelves and positions where urgent refill is required.