Forum Discussion
vincentakatoh
9 years agoHelper IV
Yield Bridge Chart
Hi, Trying to create a "Yield Bridge" chart. A Yield Bridge Chart is similar to a Pareto but has a different Line Values. Yield Bridge vs Pareto: Yield bridge shows the current yield and sub...
vincentakatoh
9 years agoHelper IV
Hi v-qiuyu-msft,
Thanks.
(1) The PBI values are not the same as Excel values that I'm wanted to achieve.
(2) The dates are important. Objective is to have drill down by dates and lines. Was really happy to achieve the Pareto line using 5x measures (keeping drill down functions such as dates and lines). Was hoping to do the same for Yield Bridge line.
(3) Thanks. Got it!
vincentakatoh
9 years agoHelper IV
Hi v-qiuyu-msft,
Apologies. Notice there are formula errors in my original excel. The new formulas maybe easier to calculate.
Appreciate your great help and patience. Really struggling to create the yield bridge chart.
Updated excel