Minus and plus

When, as a result of subtracting two values in an Excel table, you get a negative result, sometimes you don’t want the negation sign to be seen. This requirement can be solved in several ways: by formatting the display of the number using the Accounting style, by using function that calculates the absolute value of the number or by creating custom format that will display number in a manner that suits you better.

Splitting columns

For a certain period of time, when I need to split data in a column, my first choice is to use the Power Query add-in and the Split Columns option. However, there are still users who do not know how to use it, so I remembered that for this purpose we can also use the Excel option Text to Columns. In this “recipe” you will find out a practical way how to split one column into several.

New formatting options

Power BI Desktop, in its December edition, brought several new options for formatting Column and Bar visualizations, which we can use to make them much more functional and beautiful. In addition to this option, this “recipe” will show some new features that have been added to the data labels option. Relax and enjoy, here are some interesting contents…

New Slicer visual

Slicers are interactive objects used to filter pages or the entire Power BI report. They haven’t changed much since their inception, and since they represent an essential component of the report, they got a small facelift. Since November, a new Button Slicer visualization has appeared, which has the properties of traditional slicers, as well as some additional formatting options that make it much more beautiful. Let’s see what it has to offer!

Ribbon visual

Ribbon is a new visualization that has recently become part of the Power BI reporting platform. When is it used? If you want to show some indicators, for example sales revenue or total costs in relation to time, you will use either a Line or Column chart. If you hesitate between these two visualizations, you can use Ribbon, which represents the best of both!