Transform Your Line Chart in Power BI (Current vs Last Year )
In this video I show you how to build a dynamic Power BI line chart that compares the current year vs last year and shows the year-to-go last year.
I show how to:
• Build a cleanly formatted line chart
• Add a Monthly vs YTD toggle
• Display the last year YTG line
• Add a tooltip for more insights
▬ Resources ▬▬▬▬▬▬▬▬▬▬▬
⬇️ Download Power BI File:
https://file-download.yourownkpi.com/
🎨 Figma Design Course for Power BI
https://yourownkpi.gumroad.com/l/powe...
📊 High-End Power BI Template
https://yourownkpi.gumroad.com/l/aqua...
▬ Socials ▬▬▬▬▬▬▬▬▬▬▬▬▬
👨💼 LinkedIn: / zsolt-szabo-bln
📸 Instagram: / yourownkpi
🎥 Tiktok: / yourownkpi
▬ Timestamps ▬▬▬▬▬▬▬▬▬▬▬
00:00 Intro
00:35 Monthly vs YTD slicer
02:12 Monthly vs YTD measures
04:18 Selected date measures
08:16 Year-to-go-line
09:25 Restrict slicer selections
11:04 Last data point measures
13:48 Formatting the visual
18:58 KPI Cards
22:29 Tooltip
22:35 Outro
#yourownkpi #yokpi #powerbi #datavisualization #powerbidesign #dataanalytics #reportdesign #dashboarddesign