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…

3D charts

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…

Population pyramid chart

Population pyramid is a subclass of the Bar chart chart that is conenient when we need to show results of the research in which we compare two populations. Most often we compare the percentage representation. These can be answers, in relation to the age, how many survey members responded with the “YES” and how many with “NO”, we can compare the number of men and women which belong to a certain population, etc.

Win-Loss chart

If you are engaged in budgeting and cost analysis it will be useful to know how to create a Win-Loss chart. This is a type of Bar Chart chart which, on the left side, holds negative values (most often the losses), and on the right side positive values (most often the gains). On the left side there can be also shown the costs, and on the right side the revenues. Let’s take a look at how this chart works!

Fields for visualization

Various visuals, whether they are tables, cards or charts, have different fields that can be used to adjust their look within the report. We perform this action by dragging dimensions and measures to these fields. In this “recipe” you will be shown usage of fields, depending of common visuals, and how to use them to form quality reports.