Avoid interrupted hierarchy summation

[LP135]

I have data from 1980 to 2030 which I structure in a five level hierarchy tree (the hierarchy is defined in a separate table and then connected to the actual data via a relationship).

After 2017, the data is forecasted - however, only for Levels 1 and 2, so levels 3-5 are blank after that point.

Since the hierarchy leads to automatic aggregation of lower levels to higher levels, the forecasts of Level 1 and 2 are not shown in the visualization.

How can I tell Power BI that it should use the hard values in levels 1 and 2 if no values are available for levels 3-5?

Any help is highly appreciated!

[Anonymous]

HI @LP135,

It is impossible to custom on hierarchy column, maybe you can try to parent child hierarchy.

For measure, it is possible add conditions to replace value when current hierarchy level is blank and use replace value in calculations.

Regards,

Xiaoxin Sheng