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…
Data labels in charts are always useful because they implicitly show us the value of the series, without the need to look at the axis. However, in traditional charts, they are always formatted the same way; they are displayed in the same font size and style, the same color… Power BI Desktop recently got the option of conditional formatting of these values, which makes the reports much more vivid.
When we use a Stacked Row or Stacked Column chart for visualization we can add data that displays the values of individual series within a group. How is it possible to see the total value (for all series)? In Excel, we used tricks to perform this, which I described in a post from May this year, and Power BI has recently got a new option which enables display of total values for stacked charts.
When creating a Stacked Bar or Stacked Column chart, this is a convenient way to show the proportion of a product or its categories sold over a given period of time. However, even if we choose to show values on the series, it is not clear what the total sum is. Here’s a simple trick to create a chart that shows the share of each series in the sum, as well as the total sum of values.