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
For Queries ✉ : [e-mail]

[@bankimdas9517]

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

[@decentmendreams]

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

[@sadiqabkr]

Great tricks. Thank you.

[@sandipansarkar9211]

finished watching

[@mogarrett3045]

this cool

[@shraddhaverma4795]

If year change how it's works

[@perfectionist6624]

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

[@adityabidkar9395]

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

[@upendravemula7901]

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

[@MITutorials]

Yes!

[@upendravemula7901]

Could you please share video for same?

[@user-wb2kz5oo9z]

My year is in whole number still error is showing

[@user-qz5uy9kh8b]

Also me,did you find a solution??