Data bars

In Edit mode; Right click column, and select "Add data bar"

The parent rows Bergen, Oslo and Stavanger compare to each other, as they are on the same level of the hierarchy. Child rows compare to other child rows.

Once the data bar is applied, you will get a format panel for the data bar:

Minimum: default set to Lowest value in the column. Could be set to any value. If you have a value of -100, but set the minimum to "-50", then all rows with a value lower than -50 will have a full negative bar.

Similar with Maximum.

Positiv bar/Negative bar: Set bar colors.

Axis: Set axis color

Hide Axis for empty cell: Will create a break in the axis if the value is empty.

Apply for only this column: Turn this ON if you only want the data bar for one specific column. Turn this OFF, and you will get a data bar for every instance of that measure. E.g. you have years on your column header, and add a data bar to your Actual measure. Turning this OFF will then apply a data bar to the Actual column for each year.

Bar direction: Set what should be the positive direction.

Compare against: Child Group: Each of the circled child groups contain one Maximum and one Minimum Value to compare against: The child group under "Bergen" has one maximum value. The child group under Oslo has a separate maximum value. So the comparison is done within the separate child groups.

RowLevel: Each row in the circles compare against each other. The middle group has the highest value, of 2,17 million, and all other rows compare to that as their maximum value.

Optional Condition:

You can use that field to specify where you want the data bar to appear.

For instance, you can write "RowLevel()>0" to exclude data bars on the top level (top level is defined as 0):

Or you could add it only to the parent rows by using "RowLevel()==0":