Hi all, If you want to download the PBIX working file... you can go to mywebsite: Lighthouse Analytix.com. Go to free tutorial section. Look for videos on: Power BI Waterfall Chart + Field Parameter = Enhanced P&L Report and variance analysis in PBI !!! I used the same pbix file... that you can use to practice along.. Cheers, Isabella.
Terima kasih Isabella, saat ini saya sedang mulai untuk mempelajari PBI, suatu keberuntungan bagi saya menemukan Chanel YT ini yang sangat luar biasa membahas analisa keuangan. Sepertinya saya akan banyak download file di lighthouse untuk bahan saya mempelajari PBI. Sengaja saya komentar pakai bahasa Indonesia, karena nama kamu ada nuansa Indonesia nya.
"karena nama kamu ada nuansa Indonesia nya" agree hahaha...kita pelajari n like video nya Bang...jarang nih yang kasih tutorial gini, hanya beberapa yang dari indo sepertinya...
setelah kulihat namanya sepertinya orang Indo..saya pikir orang luar...Makasih Mba Isabella, ini sangat membantu, setelah melihat tutorial ini ada yang harus saya perbaiki dari struktur data dan measure yang tersebar dimana mana hahaha,harusnya ku grouping :)😍
Click your table, then go to the visualization pane on the right. Click format visual, then scroll down to Total. There is an option to turn off value. Good luck !!!
Hi ... you are welcome... and thank you for reaching out to me. I'm in the process of setting something up so that you can see my availability and book me for 1:1 session via my website.
Hi! Thank you- your videos are super helpful. If my data(coming from HFM) is all positive values (both expense and revenue), is there a way to covert expenses to negative to create performance variance measure? Thanks again !
Good example. However in my experience most difficult part is data model preparation. It is relatively easy to do it with 5-10 GL accounts. But what if you have 50+ accounts? What if your GL ledger gets new accounts from time to time? What if you have a multi-level structure of your GL?
Agree... Data model preparation is key. Where possible link your PBI data model to your source system or your data warehouse. That way, any new GL accounts as well as changes in GL hierarchy will automatically flow into your Power BI reports.
You can get it from my website. www.lighthousenalytix.com Then go to tutorial: Power BI Waterfall Chart + Field Parameter = Enhanced P&L Report and variance analysis in PBI !!! I used the same data set for both videos.
hi - we'll post it in our website - in the next 48h. In the meantime, you can also download the pbix file that we used for PBI waterfall chart + field parameters. I used the same pbix file for both videos.
Hi all,
If you want to download the PBIX working file... you can go to mywebsite: Lighthouse Analytix.com.
Go to free tutorial section.
Look for videos on:
Power BI Waterfall Chart + Field Parameter = Enhanced P&L Report and variance analysis in PBI !!!
I used the same pbix file... that you can use to practice along..
Cheers,
Isabella.
Hey Isa! Loved the content and execution of the video. And your voice is absolutely soothing!!
Lol - hope you are not falling asleep !!!
Terima kasih Isabella, saat ini saya sedang mulai untuk mempelajari PBI, suatu keberuntungan bagi saya menemukan Chanel YT ini yang sangat luar biasa membahas analisa keuangan. Sepertinya saya akan banyak download file di lighthouse untuk bahan saya mempelajari PBI. Sengaja saya komentar pakai bahasa Indonesia, karena nama kamu ada nuansa Indonesia nya.
Semangat maju terus belajar PBI ya !!
"karena nama kamu ada nuansa Indonesia nya" agree hahaha...kita pelajari n like video nya Bang...jarang nih yang kasih tutorial gini, hanya beberapa yang dari indo sepertinya...
setelah kulihat namanya sepertinya orang Indo..saya pikir orang luar...Makasih Mba Isabella, ini sangat membantu, setelah melihat tutorial ini ada yang harus saya perbaiki dari struktur data dan measure yang tersebar dimana mana hahaha,harusnya ku grouping :)😍
Terima kasih atas komentarnya... and all the best ya... :)
Very useful ... your tutorials are great, professional and very simple
Glad you like them!
Amazying! It woud be great to have a similar one comparing budget vs real data.
Coming soon!
Very useful, thank you!
You're welcome!
Great tutorial. Thanks for sharing🌹🌹👍🏻👍🏻
Thank you for the feedback! Cheers!
Hello. Great video. For the tables how to hide/ remove the Totals row.
Thanks.
Click your table, then go to the visualization pane on the right.
Click format visual, then scroll down to Total.
There is an option to turn off value.
Good luck !!!
Hi, thanks for information.. I wish to take personalized training.. please advise
Hi ... you are welcome... and thank you for reaching out to me. I'm in the process of setting something up so that you can see my availability and book me for 1:1 session via my website.
@@LighthouseAnalytix thanks would appreciate if you can share link once it is available
Hi! Thank you- your videos are super helpful. If my data(coming from HFM) is all positive values (both expense and revenue), is there a way to covert expenses to negative to create performance variance measure? Thanks again !
I would create a P&L measure that says, if expense then -1*value, if revenue then 1*value.
@@LighthouseAnalytix thanks!!
Good example. However in my experience most difficult part is data model preparation. It is relatively easy to do it with 5-10 GL accounts. But what if you have 50+ accounts? What if your GL ledger gets new accounts from time to time? What if you have a multi-level structure of your GL?
Agree... Data model preparation is key. Where possible link your PBI data model to your source system or your data warehouse. That way, any new GL accounts as well as changes in GL hierarchy will automatically flow into your Power BI reports.
hi very good presentation, can we get a link of the data file to test the same. Thank you
You can get it from my website. www.lighthousenalytix.com
Then go to tutorial:
Power BI Waterfall Chart + Field Parameter = Enhanced P&L Report and variance analysis in PBI !!!
I used the same data set for both videos.
great! how we can download your file?
hi - we'll post it in our website - in the next 48h.
In the meantime, you can also download the pbix file that we used for PBI waterfall chart + field parameters. I used the same pbix file for both videos.
Where is your date
you can add them if required.