If we analyze the chart visuals, we can often notice points with disturbances on them. These can be e.g. days when unexpected sales values occurred, completely contrary to the planned trend. Power BI Desktop, in the visuals’ Analytics section, now has the Find Anomalies option that allows it to find points on the chart that are inconsistent with trends and point to them.
When creating a report, the rule that less is better often applies. That is, instead of displaying everything with one visual, it is often a better tactic to create several smaller ones so that, by applying filters, you choose which of the data will be displayed. From now on, this procedure has been further simplified by introducing the Small Multiples option. It allows you to split one chart into several smaller ones based on a given dimension.
Power BI Desktop got another new feature in its November release. For visuals that contain too much detail, it is possible to turn on the Zoom Slider option. It allows you, without the need to create additional filters, to zoom the contents of the slider and gain a better insight into the displayed data. This option does not affect any trend lines that you may have added on the chart that we want to zoom.
Conditional formatting is an Excel functionality that is often used, and allows you to emphasize certain parts of the report. Typically, conditional formatting is used within the same column, but how do we display “traffic lights“, icons that indicate a change in business, within another column? This is a very simple procedure, and if you want to find out how this is done, you have it in this “recipe”.
The Paste Special option provides a number of ways to manipulate the values that need to be pasted back into the document. One of them is calculation, where it is possible to select a cell that contains a value, and then a range with values for calculation that will perform one of the four elementary mathematical operations (addition, subtraction, multiplication, division). This can increase productivity, let’s see how it is used!