Dynamic slicer selection in customized waterfall chart

[Boris_EmV]

Hello,

I am struggling to incorporate dynamic selections of start & end bars in a custom sorted waterfall chart (Zebra BI / Simple Watefall). There is intermediate bar (Actual Normalized) which should dynamically updated based on slicer selections, and respectively all the measures/dimensions in waterfall. I would imagine using field parameter to change the categories (Other, People, IT etc), but don't have success to do that together with other dynamics.

Please find the below screenshot with explanations.

Link to the sample file: 

https://www.dropbox.com/scl/fi/n16o1djmd4xvmtln3rdl3/dynamic-waterfall.pbix?rlkey=d6ar7b5szxj7odtauz... 

Thanks in advance!

[v-yangliu-msft]

Hi  @Boris_EmV ,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Boris_EmV]

Hi,

Thanks for your reply. 

Basically, these 2 waterfall charts I want to combine into 1 by slicer selection for Actual/Forecast/Budget combinations and change of Store & Brand categories also by slicer (field parameter maybe).

Here is the link to the sample file:

https://www.dropbox.com/scl/fi/n16o1djmd4xvmtln3rdl3/dynamic-waterfall.pbix?rlkey=d6ar7b5szxj7odtauz...