Have you struggled to
Have you struggled to compare data from two different time periods in Power BI? Does the data just continue on and not overlap? Patrick shows you how you can easily overlay the data for comparison.
Download sample: https://guyinacu.be/twomonthssample
? Become a member: https://guyinacu.be/membership
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
? Guy in a Cube courses: https://guyinacu.be/courses
? Check out my Tools page - https://guyinacube.com/tools/
#PowerBI #LineChart #GuyInACube
Thanks for this!
Is it possible to have a Fiscal comparison/ weekly comparison STLY in similar fashion as suggested in this video?
Hi Patrick , Would you not just use the date hierarchy and delete year quarter and month to just give you day of month instead of writing a custom field
How to do for last 10 days ? Like analyise current days with last 10 lasts in line chart
The solution is simple, but I wouldn't recommend since the days on different months are not correlated. You don't want to compare sales from a friday on a month to a Wednesday on another. Having days of the week might be a better solution especially having the weeks. Not all will align, but the analysis should be better.
Hi Patrick, I was wondering if it possible to give readers of the report/dashboard the possibility to add comments in the visuals/tables shown in the PowerBI
Need help was'nt able to do it
How can you do this type of trend if you have a lot of products (132 different)? Thanks!
This guy is lost and does nothing but confuse the viewer
Added this to my youtube university playlist for excel. Great job. Thanks for making it!
Thanks man this is a life saver
This type of interactive
This type of interactive chart is great for impressive dashboards. Quickly learn how to create an Excel Pivot chart that's driven by pivot slicers.
Download the workbook here: http://www.xelplus.com/pivot-slicer-excel/
In this example I cover two topics:
1. How to get Weekday name from a given date in Excel
2. How to create a Pivot Chart controlled by a Slicer
In addition I show you how you can customize slicers in Excel to better match your report layout.
★ My Online Excel Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
New sub! Wow! Blown away with the content. Such quality, beauty, and knowledge all jam packed in each video! (Thank you, YouTube!)
Thanks its very useful to help me alot but I request u please increase your video quality its show me blur.
Hey, how do you push the workday function down to the edge and fill them in a fraction of second?
Many thanks for your excellent videos and outstanding didactic abilities. There a before and after since I subscribed to your channel. I have one question on slicers. I am working on a dashboard for my boss with a slicer on months, but I need to limit the selection to one item, i.e., one month. I don’t want my boss to select more than one month at a time. Is it possible to limit selections in a slicer to one item at a time? Many thanks again for your videos...