Show last 6 months in Power BI based on slicer selection and make number of months dynamic
In this video, we show how to show last 6 months in Power BI based on user slicer selection, and then we develop this idea further by building a parameter than can allow the user show the last 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 months. So, this parameter allows the user to show the last n months , where n is the number of months selected by the user.
Download Example Files:
https://tinyurl.com/5u3sw4ch
Check out how I Implemented this trick on Part 2 of my Call Center Dashboard:
• Complete Power BI Dashboard for Call ...
Thanks to the SQLBI guys, Marco Russo & Alberto Ferrari for the inspiration that I got from their video:
• Show last 6 months based on user sing...
Contact us for training or consultation: https://Excelbonanza.com/Contact
⭐Check out my Courses:
ExcelBonanza.com/Courses
Time Stamp:
00:00 Introduction
01:31 Introducing the data model
01:59 Creating the Month and Year column on the Date table (Calendar Table)
05:30 Defining the problem that we have when trying to show the last 6 months of Data
06:47 Creating the duplicate Calendar table and connecting it to the data model
12:15 Creating and explaining the measure that will solve our problem
22:57 Creating a parameter to make the number of months that we show dynamic
25:44 Practical application - Call Center Dashboard
26:30 Credit to SQLBI (Alberto Ferrari and Marco Russo)
27:09 Conclusion
Follow us on Social Media:
Facebook: / excelbonanza
Twitter: / excelbonanza
Follow me on Linkedin: / abdelrahman-abdou-60240150
Instagram: / excelbonanza1
TikTok: / excelbonanza
Telegram: https://t.me/ExcelBonanza
Website: https://www.ExcelBonanza.com
****My online Excel Courses****
https://www.excelbonanza.com/courses/
