Create Custom Column Chart to display Years, months, YTD in Power BI | MiTutorials

Welcome to another Power BI tutorial! In this video, we'll show you an awesome hack to enhance your data visualization skills. We'll guide you through the process of creating a dynamic and informative column chart that displays sales data for previous years, the same period last year, and year-to-date (YTD). We'll also make use of a slicer to select year for a comprehensive analysis.

Whether you're a beginner or an experienced Power BI user, this tutorial is designed to help you level up your reporting and analytics game. We'll provide step-by-step instructions and valuable tips to make the process smooth and easy to understand.

Key Topics Covered:

Setting up your data model for time-based analysis
Calculating previous year sales
Calculating same period last year sales
Calculating year-to-date (YTD) sales
Building an interactive column chart
Customizing visuals for a polished look

[bankimdas]

It's always amazing and fun to learn amazing things from your tutorials👌👌👌👌👌

[decentmendreams]

Always relevant techniques. I love your videos. Thank you .

[perfectionist]

I think it's better to create a Slicer for
MTD
Qtd
YTD
Lastmonth
Today
Yesterday


So that end user can select it and check data accordingly

[adityabidkar]

Explain why you have used Max() to calculate total sales for Jan to Dec & YTD in the dax?

[wbkzooz]

My year is in whole number still error is showing

[upendravemula]

Very useful video.. can we show years based on slicer selection.. like if I select 2020 then I should get 2017 2018 2019 n 2020 monthly data