Тёмный

Power BI Waterfall Chart + Field Parameter = Enhanced P&L Report and variance analysis in PBI !!! 

Lighthouse Analytix
Подписаться 8 тыс.
Просмотров 19 тыс.
50% 1

What I love about PBI is that it is always evolving..
New features are constantly being released…
In May 22 release… we have a new feature called Field Parameter, which is a true Game Changer in the way we design our PBI report.
In this video, I'm combining field parameter with the trusted waterfall charts so that we can allow users to select what value to display as well the breakdown to display.
The result is super amazing !!! Hope that you will love this new features as much as I do.
Cheers,
Isabella Susilowati
‪@LighthouseAnalytix‬
#powerbitutorialforbeginners, #Powerbi, #powerbitutorial
LA58

Опубликовано:

 

2 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 49   
@Oscar_Mendez
@Oscar_Mendez Год назад
Amazing video. You explain thing very simple! Thanks
@LighthouseAnalytix
@LighthouseAnalytix Год назад
You're welcome! 😊
@adnanazad6102
@adnanazad6102 2 года назад
True game changer indeed, terima kasih!
@LighthouseAnalytix
@LighthouseAnalytix 2 года назад
:)
@bensonchua2117
@bensonchua2117 Год назад
Great stuff!
@LighthouseAnalytix
@LighthouseAnalytix Год назад
Thanks!
@low_quality666
@low_quality666 Год назад
awsome!
@LighthouseAnalytix
@LighthouseAnalytix Год назад
Thanks!
@ronaldbaronirojasguerrero7831
excelente video
@LighthouseAnalytix
@LighthouseAnalytix Год назад
Thank you !!
@ommm4169
@ommm4169 Год назад
Thanks.. very helpful... it would be great if we could have the working files / sources to practice it
@LighthouseAnalytix
@LighthouseAnalytix 10 месяцев назад
Noted
@ljiljanaivic4166
@ljiljanaivic4166 Год назад
Thanks! This was very helpful! But I don't understand next: if increase is red, decrease green, what means ''other'' in yellow color because there is some value, it's not 0?
@LighthouseAnalytix
@LighthouseAnalytix Год назад
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.
@rishabh1993
@rishabh1993 Год назад
Thanks. I have question is there way to automatically select last year if I select only the current year in the slicer.
@LighthouseAnalytix
@LighthouseAnalytix Год назад
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.
@rishabh1993
@rishabh1993 Год назад
@@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.
@user-gt4lg8hm4c
@user-gt4lg8hm4c Год назад
Hi, May I know how to display the waterfall chart as %change? To show 100% at the start and then the breakdown also in %terms where the end is the year on year % change.
@LighthouseAnalytix
@LighthouseAnalytix Год назад
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.
@paulinasanchez3009
@paulinasanchez3009 Год назад
Super helpful! Do you know how to change the start and end of the chart based on the selection of two slicer?
@LighthouseAnalytix
@LighthouseAnalytix Год назад
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.
@paulinasanchez3009
@paulinasanchez3009 Год назад
@@LighthouseAnalytix thank you sooo much!
@karinahulka9980
@karinahulka9980 Год назад
thanks for the video! so what is the difference in this case between using slicer and field parameter?
@LighthouseAnalytix
@LighthouseAnalytix Год назад
without using field parameter, you can only use slicer for showing selections on your ''DIMENSIONS' and not ''MEASURES'
@punchbuddies220
@punchbuddies220 Год назад
Hello Beauty, Quick one - How do you do Power BI waterfall chart comparing YTD Current Year vs YTD Last Year? Many thanks.
@LighthouseAnalytix
@LighthouseAnalytix Год назад
Hello - thank you for your kind greetings. Have you seen one of my older videos on how to make waterfall charts in Power BI? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PJkKRODCciM.html
@music-hn2jv
@music-hn2jv Год назад
Thank you. How does the waterfall show the most relevant variances so that the colum "Others" doesn't hide a big portion of the delta ?
@LighthouseAnalytix
@LighthouseAnalytix Год назад
Go to visualization pane, format your visual, breakdown... and adjust the maximum breakdown shown...
@music-hn2jv
@music-hn2jv Год назад
​@@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.
@LighthouseAnalytix
@LighthouseAnalytix 10 месяцев назад
Thought they were ranked based on the 'largest' value
@growlife4779
@growlife4779 2 месяца назад
How did you get the other to be in a different colour? and also how did you add Other if its not a measure? Many thanks
@LighthouseAnalytix
@LighthouseAnalytix 2 месяца назад
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.
@arbazahmad7177
@arbazahmad7177 Год назад
Great 👍. Kindly mention practice workbook file link also.
@LighthouseAnalytix
@LighthouseAnalytix Год назад
Will look into it.
@daphne1213
@daphne1213 Год назад
I’m having issues with x-axis not organising according to chronological order. Any fix for this?
@LighthouseAnalytix
@LighthouseAnalytix Год назад
You need to sort the x axis.
@daphne1213
@daphne1213 Год назад
@@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?
@watcher1818able
@watcher1818able Год назад
@@daphne1213 I also tend to have issues with this. My workaround I use: I set the date to "date" instead of "date hierarchy".
@watcher1818able
@watcher1818able Год назад
Hi. New Parameter is not giving me an option to select field parameter. Default is what-if only
@LighthouseAnalytix
@LighthouseAnalytix Год назад
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.
@watcher1818able
@watcher1818able Год назад
@@LighthouseAnalytix many thanks!
@archanasahoo3738
@archanasahoo3738 Год назад
In this path field parameter not showing
@archanasahoo3738
@archanasahoo3738 Год назад
Which version power bi needed for this feature
@ChvpdVara
@ChvpdVara 2 года назад
Can we do same in Ms Excel?
@kidzaurus
@kidzaurus 2 года назад
It will be a bit tricky to set up
@LighthouseAnalytix
@LighthouseAnalytix 2 года назад
For this scenario, setting it up in PBI will be simpler than setting things up in Excel.
@j.a_9756
@j.a_9756 Год назад
mba dari indonesia kah ?
@LighthouseAnalytix
@LighthouseAnalytix Год назад
iya 😊
@j.a_9756
@j.a_9756 Год назад
@@LighthouseAnalytix hebat banget 👍 success terus mba ✨✨
Далее
would you eat this? #shorts
00:23
Просмотров 2 млн
Waterfall Chart in Power BI - Visuals with Nags
15:38
MASTERING Bar Charts in Power BI | No more Cut Labels
15:34
Power BI Waterfall Month by Month example
23:59
Просмотров 15 тыс.
Power BI Waterfall Chart in details
7:57
Просмотров 2,3 тыс.