Make this Creative & Insightful Line Chart in Power BI 📈

In this video, we'll learn how to make a cool line chart in Power BI that displays growth over time. It's a great way to showcase your data in a creative and visually appealing way. Follow along with our step-by-step tutorial and learn how to create your own line chart in no time!
Gustaw Dudek - / gustaw-dudek
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File ⬇️ - goodly.co.in/Creative-line-ch...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - [e-mail]
===== CHAPTERS =====
0:00 Introduction
0:42 The four-step process
2:33 Interacting slicers
4:13 The error bars
06:52 Creating a constant line
07:40 Adding markers
08:11 Data label & Conditional formatting
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[@jonahviakeyboard]

Thank you so much for the walkthrough! Gustaw Dudek's techniques are amazing and I always wonder how exactly they work. There's enough to fill a whole of course! Thank you again.

[@DeronHuskey]

Nifty! I love the way you dismantle these issues and put them back together. Thanks!

[@Soulenergy31]

Thank you Guru! 2:17 table of content of what is needed 10:20 building the chart

[@joaorataoo]

Amazing. The creativity allied to technical ability is fabulous. Congratulations on the excellent result.

[@miguelbenito7992]

Thank you! Your content is so addictive!

[@mohammadaamirkhan7830]

Wow! Awesome video! You are using hard and advance DAX to make such kind of visualization, that is Amazing! Thank you for making this visual.

[@mnowako]

Good lesson as always, thank you!

[@cristian.angyal]

Great explanation Chandeep! 👏 Thanks for sharing!

[@ahmedbenchaoued9765]

just perfect !! big Thanks, so addictive like always !!

[@tinaflemons263]

Wow, I can't wait to try this. Thank you

[@unnikrishnansanthosh]

as always excellent, thank you for sharing

[@user-it6zv1bf9d]

you are best sir, it solve my issue in my current company

[@emilmubarakshin49]

Excellent chart, thank you Chandeep!

[@rrestituti]

Amazing!!!!! Thank you very, very, very much!!!! You're awsome.

[@mazchen]

Explanations started really well and easy to follow. However focusing a bit more on the DAX would have been great!

[@randomguy-jo1vq]

As always you are the best

[@OdelLeal]

Great work. Amazing.

[@arunkumarkesavan6077]

Chandeep !!! If Microsoft PowerBI team have a chance to look at your video, then you are one of the top notch in their team !!! Similar to nifty 50 your knowledge on the PowerBI always breaches all-time high.... Happy to be your subscriber !!!

[@GoodlyChandeep]

Thanks Arun :)

[@davitmovsesyan1088]

Really liked the creativity

[@vinipowerbi]

I tried it , thank you so much

[@zonziriguekonate1066]

Really Nice. Helpful 👏

[@pondyanand]

Just brilliant !!!

[@user-hq3xx8sf9r]

THIS IS BRILLIANT!!!!!!

[@roywilson9580]

Thank you, very interesting video.

[@edwinarchico439]

This is fantastic, please do more of this❤

[@DataDashPro]

if you want you can look to excel version of same chart here.kzbin.info/www/bejne/g4bChKaIq82prMk

[@manojkahar5718]

Very Ausome Chart, Really impressive

[@vijaypangare1044]

You makes things more Complicated

[@chrism9037]

Wow, amazing Chandeep, thanks!

[@DataDashPro]

if you want you can look to excel version of same chart here.kzbin.info/www/bejne/g4bChKaIq82prMk

[@rashmikrishnamohan1736]

Amazing!!!

[@luisfernandomacedo1451]

Hold on! Lemme pick my laptop, and do it while you teach us

[@DeronHuskey]

7 months later I needed to do a re-watch. Thanks again.

[@KhalilAhmad74036]

Thank you so much

[@kunwang2279]

Briliant. I am wondering if this tech could be applied to bar / combo chart. I want to have bar charts have lines link the bars and the difference of the bar value in the middle.

[@TheProjectCorner]

I'm so sad that I can only give this video 1 thumbs up. This is amazing!

[@GirdharVerma]

this is amazing

[@kishorpatil8460]

Finally Sir you made it as said..

[@Dev_Bartwal]

You are awesome ❤

[@anilyadav-rt4sr]

Thanks Sir ji that is nice topic

[@MujtabaAdil-pc4wo]

Guru sir ,...love it

[@dikshasrivastava9125]

Hey Thanks for the video. Can you please provide dax for line and marker as well.

[@iamsd346]

1:42 Its the other way around The first two segments of line are the vertical lines and the horizontal line is the connecting line.

[@zorankrekic3006]

Very nice, top

[@tnssajivasudevan1601]

🙏 Excellent

[@PLara-tf4eg]

Great, this is awesome. I wonder if this can be replicated with a Waterfall Chart 😮

[@DCHHolman]

THat is a proper chart sir!

[@dimitrigbo823]

Amazing

[@Omkar_Data_Analyst]

can you please make a video on how to calculate same period last month keeping date filter as same days

[@sahmedalee]

Just made it last week after watching Gustaw LinkedIn post

[@user-ik5tv6hi4t]

Thank youuuuuuuuuuuuuuuuuuuuuuu 😊😊😊😊

[@balasankar1483]

Can you please make a video on How we can connect SQL Server in Microsoft Fabric and How we can use copilot in power bi services to develop the report.

[@danielnemeth123]

Hello Guys, first of all thanks for the video Chandeep, amazing what you and BI capable of. I would request a little bit of help, Im stucked at creating the constant line, could someone hlep me out? Thanks, keep up the good work!

[@juanignacioXI]

This is awesome Chandeep! Thanks a Lot.

[@GoodlyChandeep]

Glad you liked it Juan!

[@tomduffhues622]

Amazing video Chandeep! Really really nice 1 remark and 1 question Remark 1. I recreated the chart, however I want to YoY comparison. As soon as I enter '13', the MAXX function picks sums both months (may 2022 and may 2023), giving a much higher 'line' value. This was fixed by taking a yearmonth (unique) approach, similar as your slicer. Took me a while to figure out... Question 1. What if I want to pick my comparison month also from a slicer. Would I then need a secondary disconnected date table and instead of periods use that one? What are your thoughts?

[@ismaelpizarromedina4343]

Could you share the dax pliss i got the same problem

[@sheshikumarausheni9428]

Hey goodly Please make a video on customer 360 dashboard

[@ScottPerley]

Loved the video! I haven't been able to figure out how you got the slicer to only show one value at 3:50.

[@remib5863]

I believe it is a what if parameter

[@ismaelpizarromedina4343]

Same question here

[@DataDashPro]

if you want you can look to excel version of same chart here.kzbin.info/www/bejne/g4bChKaIq82prMk

[@chouyueh89]

i managed to complete it! but i want to be able to do for quarter and year too, does anyone have any suggestion?

[@navyachowdary3353]

How to find the difference where if we select one point in line graph and when I move my mouse over my line chart I should get change percentage from first point to mouse moved point instead of selecting the months

[@tanvir501]

Hey, Chandeep, Another amazing lesson. Thank you. The download file had been showing as not safe by the browser security for many videos of yours. I was wondering if this is a common issue for others too and If it is, can you fix it.

[@GoodlyChandeep]

Thank you for bringing this to my attention. While I haven't received any similar reports from other viewers, I'll investigate the issue with the download files and see if I can fix it. And the files are safe to download :)

[@ManishKumar4993]

How did you do the formatting as per the thumbnail?

[@ragygadelkareem2880]

is there a way to do it in quarters instead of months ? what needs to be changed ?

[@LinhTran-ix4mr]

Thank you for the useful video! Question. Can you explain the variable Period = [Period Range], it's in the SalesPoit calculation. I can't find where of the period range you have in your data model. Thank you!

[@vianassantos]

I got the same question. IDK but i think its "SELECTEDVALUE(PeriodRange[Period])"

[@a.7388]

My man, nice video, although that thumbnail is a little bit misleading

[@maximpiras]

Really great stuff Chandeep - Thanks for sharing! Just one question. In your Sales Point measure, I noticed you reference another measure [Period Range] How is this one calculated?

[@yaseen2446]

u got the answer? same question i have

[@ismaelpizarromedina4343]

I had The Same doubt, I endendup downloading the file and copying the calculation you mention

[@vianassantos]

Where its the file please?@@ismaelpizarromedina4343

[@rohit2492]

Chandeep, I have been facing an issue while filtering a tile view and its associated hover view. Can you please help me with the same?

[@brightonalbert3237]

if am interested in finding the total cumulative sales between the points i.e. (start Month - End Month) how would do that i.e. total sales between the points

[@zorankrekic3006]

Again nice, but on page I have 6 Line chart, with time period 10 years, and all have same focus first date, when I select last month and 6 months befor I got info on line chart, but focus on all line chart are same first date, and selected month is out line chart and now I should all line chart with slider move to the seelcted month. How can get automatically focus on selected month and year on all line charts?

[@dinesha9152]

It's super cool chandeep.... actually my manager asked same chart recently...thank God u solved it actually 😂

[@GoodlyChandeep]

No problem, just doing my part to save the world, one chart at a time! 😉

[@susovonnath2654]

Please make a video on ''HOW TO REMOVE NON BREAKING SPACE IN POWER QUERY''

[@_Khan_Vlogs]

Please help with Constant Line DAx

[@tinaflemons263]

I tried this but can't figure out two dax calculations. Can someone provide the dax calculations for the marker and the line. It was not shown in the video.

[@Mat-ml9oq]

Marker enabled in the chart draws a line between the two points for me, so I had to take it out. I used Sales Point as the Upper bound and Marker as the Lower bound to solve this.

[@DataDashPro]

if you want you can look to excel version of same chart here.kzbin.info/www/bejne/g4bChKaIq82prMk

[@coynessglory3]

Can you do same with column /bar graph? AND with dimensional parameters?

[@DataDashPro]

if you want you can look to excel version of same chart here.kzbin.info/www/bejne/g4bChKaIq82prMk

[@gururajv6385]

Thanks a lot and its amazing. I tried this but not getting the output. I have downloaded your PBIx file but I cannot get the same Sales Point output in my report. Can you please help me

[@ismaelpizarromedina4343]

A problem i notice was you have to fix the Way the months are sorted

[@DataDashPro]

if you want you can look to excel version of same chart here.kzbin.info/www/bejne/g4bChKaIq82prMk

[@danishkhatik3955]

But when user selects chart the slicers are get invisible how can we avoid that

[@chandramohan1418]

Could yu please do this in EXCEL?.pl.thank yu

[@setis]

looks amazing, I keep getting the error "an invalid numeric representation of a date value was encountered"

[@DataDashPro]

if you want you can look to excel version of same chart here.kzbin.info/www/bejne/g4bChKaIq82prMk

[@minamishail_Tech2024]

Hi, can I use Power BI and other Microsoft analytics tools on MAC, or it's not supported?

[@DataDashPro]

if you want you can look to excel version of same chart here.kzbin.info/www/bejne/g4bChKaIq82prMk

[@DeepakChauhan-mn5jw]

Query - If I select Dec-2012 with 2 as value in previous months filter, the visuals go outside the preview. Any way to make them visible?

[@GoodlyChandeep]

Add more data :)

[@kot23]

Hey this is an amazing lesson, and very well explained. But I can't think of a real-life scenario that this visual might be useful; the users I have contact with would never bother to click on a slicer to select a month and then on another slicer to select the previous periods, they would simply ignore the visual and go to a simple table where the whole info is shown. Stil, this has a great oompf! factor and makes and great first impression.

[@arbazahmad7177]

Great 👍 but very long DAX 😢

[@MujtabaAdil-pc4wo]

Do you provide any online [owerbi cpurse ?

[@GoodlyChandeep]

Goodly.co.in/products

[@GirdharVerma]

in my power bi desktop i am not seeing directly converting table to chart from graph's top right corner, can you please help?

[@DataDashPro]

if you want you can look to excel version of same chart here.kzbin.info/www/bejne/g4bChKaIq82prMk

[@pandharinathjoshi6565]

Sir if possible make in Excel sheet also sir💐💐

[@DataDashPro]

if you want you can look to excel version of same chart here.kzbin.info/www/bejne/g4bChKaIq82prMk

[@rehammostafa4511]

I did salespoint and label as you did but it doesn't work with me.

[@DataDashPro]

Hi excel version is also possible. kzbin.info/www/bejne/g4bChKaIq82prMk

[@roberttyler2861]

How would this work for by weeks? There is no EOweek function

[@GoodlyChandeep]

Just add a week number column in your calendar table. Rest of the things in DAX will change accordingly.

[@roberttyler2861]

@@GoodlyChandeep The DAX reflects EOMONTH periods though? It feels like this would need to change as otherwise selecting 2 periods or so would just show over the 8 weeks

[@lauramccullough8633]

How can I make this work with Weeks instead of months??

[@GoodlyChandeep]

You need to have a week column in the calendar table Then alter the visual and calculation to account for the week instead of the month.

[@cupidvivi]

can't download the file, the link is not working...

[@GoodlyChandeep]

goodly.co.in/wp-content/uploads/2023/06/Creative-Line-Chart-in-Power-BI.zip

[@user-sn6lz7cu4o]

ERROR BARS IS NOT IN THE POWERBI FORMAT IN JULY VERSION

[@DataDashPro]

if you want you can look to excel version of same chart here.kzbin.info/www/bejne/g4bChKaIq82prMk

[@thebhaskarjoshi]

Your T-shirt has some printed characters that distracted throughout the video.

[@itikshamittal]

How to calculate Period Range?

[@DataDashPro]

if you want you can look to excel version of same chart here.kzbin.info/www/bejne/g4bChKaIq82prMk

[@jerrydellasala7643]

Where's the file Data.xlsx? Why bother to zip one file? It saved 3-4 KB! I have TWO Data.xlsx files from your previous videos, but they're not what's needed! Please provide!!

[@shanzeafreen8335]

Heyy, is it just me or video quality is actually not OK?

[@santoshhmt]

Hi Same i am also trying getting below error, can you help me on this The MAX function only accepts a column reference as an argument. On Salespoint Measure Sales Point = VAR CurrentMonth= EOMONTH(MAX(Dim_Date1),0) VAR Period=[PeriodsRange] VAR Dates=DATESBETWEEN(Dim_Date1,EOMONTH(CurrentMonth,-Period)+1,CurrentMonth) VAR FilteredCalendar= CALCULATETABLE( 'Dim_Date', TREATAS(Dates,Dim_Date[Date]) ) VAR TopTable=DATESBETWEEN(Dim_Date[Date],EOMONTH(CurrentMonth,-Period)+1,EOMONTH(EOMONTH(CurrentMonth,-Period)+1,0)) VAR BottomTable=DATESBETWEEN(Dim_Date[Date],EOMONTH(CurrentMonth,-1)+1,CurrentMonth) VAR UnionTopBottom=UNION(TopTable,BottomTable) VAR MaXOverturned= CALCULATE( MAXX( ALLSELECTED(Dim_Date[MonthName]), CALCULATE([_m1 Overturned]) ), FilteredCalendar ) VAR OverturnedinPeriod= CALCULATE( [_m1 Overturned], UnionTopBottom, KEEPFILTERS(Dim_Date) ) RETURN IF(OverturnedinPeriod,MaXOverturned+500)