At Lighthouse Analytix, our goal is to show you that there are ways to do things differently, which will allow you to be better, faster and more effective at work. We will be creating videos about Microsoft Excel, Power BI, Financial Modelling Tips & Techniques as well as useful Tips for personal growth & development. Our videos are summaries of the lessons that we have learnt from over 20 years working in various analytical roles as well as training various analysts who went on to develop their career as managers and leaders in their fields. We sincerely hope that our videos will inspire you to experiment, practice and share with others. Please subscribe if you'd like to improve your skills and if you aspire to enhance and grow your career. We will publish new videos every week !!! Cheers, Isabella Susilowati My Excel Modelling course is available here: lighthouseanalytix.com/
Dropdown layout isn't available and I'm using the latest version of PBI desktop. The only styles I see are 'cards' and 'table'. The data source is a dataverse table and the column type is single line of text.
I have been searching for something similar and this works really well. The explanation is just precise and perfect. Thank you for making our life easier :)
Love your videos, especially the PowerBi. I am based in Adelaide and my employer is looking for a new CFO, it would be a dream to have someone like you onboard 🤩
How can we do continuous analysis in key influencer. What kind of dataset does it expects. Since I have kind of cost data, where for each product I have costs associated. Now I want to find why the cost is increasing or decreasing. But it shows me no influencers found.
Hello... thanks for taking the time to leave some comments. I don't currently have a video on finance lease calculation. What type of calculation are you thinking of developing in PBI?
I am so happy got respond from you.. tqvm. I.m thinking of developing finance lease ammortization shcedule in power bi. Currently im struggle to calculate monthly finance lease liabilty for all my lease asset
Thank you so much for the informative video..I have one question please, I have a chart showing percentages of what people from different areas(cities)prefer to do in weekends, let's say 23% prefer to read books , but this percentage covers the whole country (different cities), how to show from that chart where are people who prefer to read with percentage/city? Thanks in advance
I want to sync slicers, which columns belong to two bridge tables(bridge tables are common merge tables for main tables) separately with different values but relative to the main table.
Yeah, we recently noticed it (the DevScope visual) stopped working in our embedded reports; can't even do 20 values as embedded no longer supported. I emailed the vendor - they may offer an older version that doesn't have these limitations, but without Support. Another option: there is a "Mass Filter" vlsual that seems to work the same and without limitations. p.s. Thanks for video!!
I have been driving myself insane trying to figure out why my location wasn't matching. This is the first resource that suggested combining columns. I'm intermediate at PowerBI, so it was very exciting to level up! Thank you!
The trouble is the company DevScope want to charge a user licence after 1 month of free use of this filter! $11 per user per annum which soon gets expensive
Hi Ma'am I quite understand your videos. Also, I implemented it as well. I have a doubt about how to navigate the button by using a single click instead of ctrl+click
Hello... thanks for the tips about HASONEVALUE DAX, something that I haven't explored previously and now keen to explore. Glad that you asked about the slicer that I have included in that report, which is displaying the values of the measure. I will be posting a video about it next week.