Forum Discussion

vincentakatoh's avatar
vincentakatoh
Helper IV
9 years ago

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...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi vincentakatoh,

 

1). We select the "Line3" in Line slicer, it's the correct values.

 

 

 

2). As YieldBri calculated column uses LOOKUPVALUE() function to return results, if add a 'data'[date] column in SUMMARIZED() function, it will have multiple records when search use LOOKUPVALUE() which can't be determined. As the final YieldBri multiply each row value, we require LOOKUPVALUE() function. I would suggest you don't use date to filter it.

 

 

3) It seems you want to add a secondary Y-axis for the line, you can turn on this feature:

 

 

Best Regards,
Qiuyun Yu

vincentakatoh's avatar
vincentakatoh
Helper IV
9 years ago

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's avatar
    vincentakatoh
    Helper IV
    9 years ago

    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