Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |