Waterfall Chart Help

[Thiyagu]

Hi All,

Thanks in Advance..

I have a chart in my excel like below and i have to make this like one in PBI.

Highlighted are LY and CY.. and the middle red and green are deviation.. 

Each red and green are calculated in PBI as measures.

So my problem is how can i replicate exactly like above image.

Kind Regards,

Thiyaga

[v-sihou-msft]

@Thiyagu

For your requirement, you may try waterfall chart or some custom visual like Ultimate Waterfall chart.

Regards,

[Thiyagu]

First one is LY Actual and last one is CY Actual. middle red / green are measures.. In excel i can place the logic in a cell and create the waterfall chart easily... My customer eagerly needed this one.

Thanks for your help again.

[sgsukumaran]

The only way you can achieve this to pre calulate the highlights and values on a measure level and break it down by atrributes.

[Thiyagu]

Could you explain little.. I'm not getting you

Thanks

[Thiyagu]

Hi @v-sihou-msft,

Thanks for your response, and apologies for delay from my side.

Actually, i did tried Waterfall chart, but in waterfall chart Y-Axis we can able to place only one measure. And other in Breakdown. In my scenario, all the values showed in my above image are all measures.. So how can i achieve this.

Thanks,

Thiyaga