Card is a visualization that is often used in Power BI reports to display some static data, for example: total revenue, total costs, profit, number of employees… This visualization has not changed since the beginning, and since a few months ago Card (new) visual appeared, which has all the functionality of Card and some new features. First, it offers easy simultaneous display of several indicators, and then there are numerous options for their formatting…
The simplest way to modify Excel charts and add new elements is by using the menu displayed in their upper right corner. Based on this functionality, Power BI received an option for modifying and formatting visualizations, which is called on-object interaction. It enables easy addition, modification and removal of report dimensions and other display elements, as well as customization of the appearance of the visual…
A large number of Excel charts also have their 3D version. Although in most cases this is just unnecessary embellishment, making it difficult to draw conclusions, sometimes 3D charts really do make sense. In the text that follows, you will find out how to make this type of chart, as well as how you can change the perspective of looking at the data…
When working with large tables, it is often necessary to make their search easier. One of the ways to do this is by applying the option for conditional formatting, with which we can mark all rows in which a value corresponding to the given criteria was found. In the next “recipe” you will find out how to perform such task.
This function, for given start and end date, calculates how much time has passed in years, and as a result returns a decimal number. It can be used to calculate annual interest, future value and in other cases when it is necessary to know how many years have passed. In the text that follows, through a simple example, you will get to know this function.