Are you overweight? Weight gain is not just an aesthetic problem, it can be the cause of many diseases, so companies conduct an annual physical examination to check the health of their employees. In this example, you will learn how to calculate BMI (Body Mass Index), a coefficient that indicates whether you are below or above the optimal body weight, and how to use conditional formatting to mark those who have unfavorable BMI.
Decomposition Tree is a Power BI visual that allows data analysis according to multiple reporting dimensions. You can view it as a sophisticated drill down tool. It performs data aggregation and gives the possibility of drilldown according to the given dimensions, and it also contains elements of artificial intelligence that help in the analysis and indicate the solution.
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.
Power BI Smart Narratives represent a new feature that allows you to add automatically generated description, derived from one or more visuals, in which are shown business trends emerging from the report. Smart Narratives are automatically generated in English, but the text can be manually edited (translated) and formatted in the desired way. It is also possible to add new values to narratives based on a given formula.
Pivot tables often store data in the cache, and some of that data is also that about slicer elements. Slicers take values from the source table. If we add some of them and then delete them, it may happen that the slicers show phantom values. They are shown in pale color, as if there is no data. And indeed, if we pick such a value, we will get an empty pivot table report. How can slicer elements always be up to date?