You're welcome! 😊

:)

Noted

Thank you !!

Thanks!

Thanks!

Others, which currently get displayed in yellow colours, means... ''everything else". For example if there are 10 cities. Year on year sales may be going up in some cities... and going down in some cities. Power BI are likely to display only the biggest influencer in the waterfall ... for example... displaying top 2 cities with sales going up... in Green bottom 2 cities with sales going down... in Red and everything else... the 6 cities... will be added together and lumped in as others, in Yellow.

Hello - thank you for your kind greetings. Have you seen one of my older videos on how to make waterfall charts in Power BI? kzfaq.info/get/bejne/hrCbfrWAqanHmYE.html

Go to visualization pane, format your visual, breakdown... and adjust the maximum breakdown shown...

​@@LighthouseAnalytix Appreciate your answer. But in this case I don't want to expand the number of breakdowns but want to show the biggest deltas in the same number of breakdowns. Apparently, the standard waterfall doesn't show the biggest variances, but the first ones.

Thought they were ranked based on the 'largest' value

go to format pane on the right and look for the settings to change the colour... The Other is automatically added by PBI. You don't need to create it.

we just need 1 slicer, get the user to select two items, and you can structure it to become the start and the end. E.g. if it is year, then if the user select 2021 and 2022, then the waterfall can start at 2021 and finish at 2022. if you want it to be month and year, then create a slicer where the selections are month & year, so that the user can select Jun-22 and Dec-22, for example, which can then be the start and end of the waterfall.

@@LighthouseAnalytix thank you sooo much!

without using field parameter, you can only use slicer for showing selections on your ''DIMENSIONS' and not ''MEASURES'

Will look into it.

interesting question... I have never tried that before. You would need to create another measure "% change of total", and then drop that in the tool tips area.

You need to sort the x axis.

@@LighthouseAnalytix I have sorted the x axis using a relational table however it is still not working. Is there an alternative way of sorting it?

@@daphne1213 I also tend to have issues with this. My workaround I use: I set the date to "date" instead of "date hierarchy".

I can't think of anything right now. But if you always want to show just this year and last year... I wouldn't include a slicer. I'd just add 'year' as a filter for the visuals on the filter pane and select this year and last year as a default.

@@LighthouseAnalytix Thanks for the reply. Based on the use case that I have, if I select 202210 in the yearmo slicer then is it possible that the waterfall chart show the breakdown starting from 202110 to 202210 and if I select 202209 in the slicer then the waterfall chart changes to show breakdown from 202109 to 202209. Not sure if possible but thanks anyways.

With regards Field parameters, it is currently is still in 'preview' mode, i.e. not yet made available to public, unless you opt to turn it on... To enable it... go to File Options and settings Options Preview features and then... tick Field Parameters.

@@LighthouseAnalytix many thanks!

In this path field parameter not showing

Which version power bi needed for this feature

It will be a bit tricky to set up

For this scenario, setting it up in PBI will be simpler than setting things up in Excel.

iya 😊

@@LighthouseAnalytix hebat banget 👍 success terus mba ✨✨