Breakdowns responsive to varius data cut choices in waterfall PBI charts

[Anonymous]

Hi All,

I am looking for a solution, to prepare a changable waterfall chart, which will be showing the sales development by year, but depending on a slicer selection, the YoY change will be either broken down by products, or by countries, or by brands, etc.

To be more precise, I need to prepare a measure, to be used in the green field on the picture below, which depending on the slicer selection, will either put red, blue or yellow data field there:

Can you help me prepare such measure or point me towards different solution?  

[Mariusz · Accepted solution]

Hi @Anonymous 

I think what you are looking to achieve is possible with a combination of Buttons and Bookmarks as demonstrated in the article below.

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

Slicers can not switch visuals and Measures return a scalar value.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

Thank you Mariusz, I believe this should work fine!