Hey, I'm Fernan, a data analyst and Power BI enthusiast with over a decade of experience working with data.
On this channel we cover Power BI, from beginner tips, visualisation tricks, DAX calculations and everything in between to help you build better dashboards.
If that sounds interesting, consider subscribing, I upload new videos every week. 👋
Thanks a lot for this video! Now, what if you want to dynamically create this TOP N, but adding a condition "Total Orders > 100" for example? On my side, using the Visual level filter does not work, the TOP N is not dynamic, ending with 3 products instead of TOP5.
I think you should have put this video somewhere in the beginning . It would have been easier to pay attention on what you are doing in the rest of the videos.
I m using spark line in Matrix visual. Showing sales for last 10 months. The trend line is not showing the correct months in order. How can we sort the month in spark lines. Appreciate your response.
Hi Fernan I have this measure that returns text such as 50/12% BAC+ = IF([# BAC+]>0, FORMAT([# BAC+],"0") & "/" & FORMAT([% BAC+],"0%"),"") I want to conditionally format this measure using the following measure Met Bac+ target = IF( [bac+ target]<1, "", IF( [% BAC+] < [bac+ target] * [lower bound], "#FF4136", -- Target Not Met IF( [% BAC+] < [bac+ target]*[middle bound], "#FF8F00", -- Close to Target "#2E7D32" -- Target Met ) ) ) however, Power BI does format the text values, what am I doing wrong in this case? Thank you for all your education
Backward comparison with SAMEPERIODLASTYEAR works just fine. What I've noticed is when you're looking at YTD vs last year. For example 2024 YTD would show you the totals up to June 2024 BUT SAMEPERIODLASTYEAR will show the 12 months total for 2023 instead of Jan to June 2023?
Hello , thanks for video :) Could i ask you which version of Power BI you are using ? i mean in Data labels part you have extra options like : Title , Detail , Layout , which is later used. I have version October 2023 but do not have such option. Or is there any way , how can i change difference shown in percentage , only with options i have ( options , values , background ) . Thanks
Hi, sync slicer option and copy, paste and sync both will have same functionality and it is just different ways for synchronizing right? Or is there any advantage of using 'copy, paste and sync' over sync slicer?
sir will share to ppt also show web visual? i have dashboards with Map visuals when i embedded them into web it does not show visuals to users , is there any other way to show full dashboard with maps and all to users outside the organization ?
Hi Fernan, really a great video. I have followed al steps from the video with a 10 page Powerbi report. However; my end user can't see the page slicer to select the pages. Can you please guide what could be the issue?
Hi Fernan. Having the most difficult time creating a line graph that compares multiple previous periods; by that I mean, it goes beyond a single previous period. If the user wants to select "range =3", then the graph will display 3 years previous periods with 3 lines. Do you have a video that shows how to do this? I'm searching everywhere. I feel like I'm close but I just cannot get to the solution.
I am calculating the previous month sales and difference comparing with current and previous month but I get blank values in the column. How it is possible? This previousmonth function is not working for me.
no "Error bars" option on new Power BI version, you can enable using: File > Options and Settings > Options > Preview Features > On object interaction.
how dax to make first month or year is zero (0) exp : when we start in jan24, feb24, mar24 so on the provious month in Jan is 0 (not diff from Dec 23). thank