No video

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

  Рет қаралды 5,465

MITutorials

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 ✉ : MiTutorials08@outlook.com

Пікірлер: 13
@bankimdas9517
@bankimdas9517 10 ай бұрын
It's always amazing and fun to learn amazing things from your tutorials👌👌👌👌👌
@decentmendreams
@decentmendreams 10 ай бұрын
Always relevant techniques. I love your videos. Thank you .
@sadiqabkr
@sadiqabkr 9 ай бұрын
Great tricks. Thank you.
@sandipansarkar9211
@sandipansarkar9211 9 ай бұрын
finished watching
@adityabidkar9395
@adityabidkar9395 10 ай бұрын
Explain why you have used Max() to calculate total sales for Jan to Dec & YTD in the dax?
@perfectionist6624
@perfectionist6624 10 ай бұрын
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
@user-wb2kz5oo9z
@user-wb2kz5oo9z 8 ай бұрын
My year is in whole number still error is showing
@user-qz5uy9kh8b
@user-qz5uy9kh8b 3 ай бұрын
Also me,did you find a solution??
@upendravemula7901
@upendravemula7901 10 ай бұрын
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
@MITutorials 10 ай бұрын
Yes!
@upendravemula7901
@upendravemula7901 4 ай бұрын
Could you please share video for same?
@shraddhaverma4795
@shraddhaverma4795 5 ай бұрын
If year change how it's works
@mogarrett3045
@mogarrett3045 10 ай бұрын
this cool
Next Level KPIs in Power BI
38:08
Gerard Duggan
Рет қаралды 88 М.
Violet Beauregarde Doll🫐
00:58
PIRANKA
Рет қаралды 32 МЛН
Gli occhiali da sole non mi hanno coperto! 😎
00:13
Senza Limiti
Рет қаралды 22 МЛН
Matching Picture Challenge with Alfredo Larin's family! 👍
00:37
BigSchool
Рет қаралды 47 МЛН
How to build dynamic MTD/YTD Slicer | Power Bi | Data Analyst
11:44
Daxpert Praveen
Рет қаралды 14 М.
MASTERING Bar Charts in Power BI | No more Cut Labels
15:34
How to Power BI
Рет қаралды 114 М.
How To Create these useful Power Bi Visuals that Excel Lacks
10:55
Leila Gharani
Рет қаралды 454 М.
Show last 13 Months from Slicer Selection in Power BI (DAX)
9:49
DAX for Power BI - MTD/YTD vs Previous Years
8:18
BI Elite
Рет қаралды 41 М.
This Year VS Last Year Time Comparisons & Differences In Power BI
9:21
Visualizing Status Tracking Data in Power BI
20:45
How to Power BI
Рет қаралды 71 М.
Violet Beauregarde Doll🫐
00:58
PIRANKA
Рет қаралды 32 МЛН