Welcome to my channel! My name is Fowmy, and I'm passionate about helping you master the Microsoft Business Analytics tools including Power BI, MS Excel, Power Query etc. and get the most out of your data. Whether you're working with data, business analytics, or data visualization, this channel is for you.
On this channel, you'll find tutorials, tips, and tricks to help you leverage the latest features and functionalities of Microsoft Business Analytics tools. I'm dedicated to sharing my knowledge and experience with you, so you can gain the skills and confidence you need to excel in your field.
If you're looking to take your data analysis and visualization skills to the next level, be sure to subscribe and hit the notification bell to stay up to date with the latest content.
I tried this approach on July 2024 and the Custom label is disabled. for those with the same issue I was able to solve adding a dynamic title (Data Label > Series: Whole > Title > Custom > Segment label measure ) and disabling the value of the Whole measure label.
not working in my data. as achieved and remaining percentage in 100%stacked Bar showing their individual achieved and remaining % i stacked Colum. resulted in 4 data values in bar. how to solve this problem.
hi there, that's excellent; any hints what to do if 'complaints' (facts) are stored in one table and their `categories` (dimension) in the another one?
Hi It's helpful If possible please make a video on below use case 1. When we are in first month means Jan how it looks 2. If any month or any full quarter there is no sale how it looks 3. Alternative months no sales like that for quarter's too. 4. Instead of average can we set target If above target means red below means means also red If between below and above then green
I know how to do the calculation in my head as I've been doing it in Excel however, I was having trouble translating it into DAX. Your tutorial definitely helped putting it into perspective. Also, I'm glad there is already DAX Query View in Power BI, which really helped in visualizing the virtual tables.
Hi, Thank you very nice explanation but I have a question? What happen if I one of the categories did have a value for the period? I try to apply this technique but it still showing the category with the non value, how i can fix this, if I don't want the category there just the ones with values
I had the same issue. I got around it by wrapping an if statement around the base 0 measure to leave it null if my x axis value is not > 0. in my case it is for income so my base 0 measure is: Income Base 0 = IF([Income] > 0, 0)
Very nice Thanks for the great video can you please share me navigation wallpapers and PNG file? I want to create same page Your share is very helpful for me
This is amazing. Unfortunately this gets extremely computationally expensive in my scenario. I am ranking warehouse picks by material, and just so far in 2024 I have 2,653 unique part numbers. This measure works out great, and the tie-breaking works well. What I am unable to figure out is a second measure to calculate the number of materials where the Pareto % is less than or equal to 80%: Pareto Material Count = CALCULATE( DISTINCTCOUNT('WarehousePickTable'[Material]), FILTER( 'WarehousePickTable', [Pareto %] >= 0.8 ))
Thank you for this video. I'm wondering if anyone else has experienced this always defaulting to the Menu objects being open when moving from one page to the next (although admittedly it seems to be worse in Chrome). There is always an extra click required when going to the next page. It confuses the users. I've probably set something incorrectly. Greatly appreciate any advice on this. When using this, it would also be nice to remove the default navigation Pages menu that Power BI forces by default, otherwise there are always two navigation menus. The purpose of this for me was to give max screen size and width for those using smaller laptops. Appreciate any help on this. Thanks