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 - goodly.wordpress@gmail.com
===== 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!
Пікірлер: 124
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.
Thank you Guru! 2:17 table of content of what is needed 10:20 building the chart
Nifty! I love the way you dismantle these issues and put them back together. Thanks!
Thank you! Your content is so addictive!
Good lesson as always, thank you!
Amazing. The creativity allied to technical ability is fabulous. Congratulations on the excellent result.
Great explanation Chandeep! 👏 Thanks for sharing!
just perfect !! big Thanks, so addictive like always !!
Wow, I can't wait to try this. Thank you
as always excellent, thank you for sharing
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.
Amazing!!!!! Thank you very, very, very much!!!! You're awsome.
Great work. Amazing.
As always you are the best
Excellent chart, thank you Chandeep!
Just brilliant !!!
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 :)
Really Nice. Helpful 👏
Thank you, very interesting video.
THIS IS BRILLIANT!!!!!!
Amazing!!!
I tried it , thank you so much
Really liked the creativity
Wow, amazing Chandeep, thanks!
@DataDashPro
6 ай бұрын
if you want you can look to excel version of same chart here.kzread.info/dash/bejne/f4mTtdWLpsvcpso.html
This is fantastic, please do more of this❤
@DataDashPro
6 ай бұрын
if you want you can look to excel version of same chart here.kzread.info/dash/bejne/f4mTtdWLpsvcpso.html
Very Ausome Chart, Really impressive
you are best sir, it solve my issue in my current company
Thank you so much
Explanations started really well and easy to follow. However focusing a bit more on the DAX would have been great!
You makes things more Complicated
Amazing
Guru sir ,...love it
this is amazing
7 months later I needed to do a re-watch. Thanks again.
🙏 Excellent
You are awesome ❤
Thanks Sir ji that is nice topic
Very nice, top
Finally Sir you made it as said..
Thank youuuuuuuuuuuuuuuuuuuuuuu 😊😊😊😊
THat is a proper chart sir!
Hold on! Lemme pick my laptop, and do it while you teach us
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.
Hey Thanks for the video. Can you please provide dax for line and marker as well.
I'm so sad that I can only give this video 1 thumbs up. This is amazing!
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.
Just made it last week after watching Gustaw LinkedIn post
This is awesome Chandeep! Thanks a Lot.
@GoodlyChandeep
Жыл бұрын
Glad you liked it Juan!
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
Great, this is awesome. I wonder if this can be replicated with a Waterfall Chart 😮
can you please make a video on how to calculate same period last month keeping date filter as same days
How did you do the formatting as per the thumbnail?
i managed to complete it! but i want to be able to do for quarter and year too, does anyone have any suggestion?
is there a way to do it in quarters instead of months ? what needs to be changed ?
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?
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
9 ай бұрын
Could you share the dax pliss i got the same problem
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!
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
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?
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.
Hey goodly Please make a video on customer 360 dashboard
Please help with Constant Line DAx
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
5 ай бұрын
I got the same question. IDK but i think its "SELECTEDVALUE(PeriodRange[Period])"
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 :)
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.
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
9 ай бұрын
Same question here
@DataDashPro
6 ай бұрын
if you want you can look to excel version of same chart here.kzread.info/dash/bejne/f4mTtdWLpsvcpso.html
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
11 ай бұрын
u got the answer? same question i have
@ismaelpizarromedina4343
9 ай бұрын
I had The Same doubt, I endendup downloading the file and copying the calculation you mention
@vianassantos
5 ай бұрын
Where its the file please?@@ismaelpizarromedina4343
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! 😉
My man, nice video, although that thumbnail is a little bit misleading
But when user selects chart the slicers are get invisible how can we avoid that
Could yu please do this in EXCEL?.pl.thank yu
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
6 ай бұрын
if you want you can look to excel version of same chart here.kzread.info/dash/bejne/f4mTtdWLpsvcpso.html
Can you do same with column /bar graph? AND with dimensional parameters?
@DataDashPro
6 ай бұрын
if you want you can look to excel version of same chart here.kzread.info/dash/bejne/f4mTtdWLpsvcpso.html
Please make a video on ''HOW TO REMOVE NON BREAKING SPACE IN POWER QUERY''
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 :)
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
9 ай бұрын
A problem i notice was you have to fix the Way the months are sorted
@DataDashPro
6 ай бұрын
if you want you can look to excel version of same chart here.kzread.info/dash/bejne/f4mTtdWLpsvcpso.html
Hi, can I use Power BI and other Microsoft analytics tools on MAC, or it's not supported?
@DataDashPro
6 ай бұрын
if you want you can look to excel version of same chart here.kzread.info/dash/bejne/f4mTtdWLpsvcpso.html
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
6 ай бұрын
if you want you can look to excel version of same chart here.kzread.info/dash/bejne/f4mTtdWLpsvcpso.html
looks amazing, I keep getting the error "an invalid numeric representation of a date value was encountered"
@DataDashPro
6 ай бұрын
if you want you can look to excel version of same chart here.kzread.info/dash/bejne/f4mTtdWLpsvcpso.html
I did salespoint and label as you did but it doesn't work with me.
@DataDashPro
6 ай бұрын
Hi excel version is also possible. kzread.info/dash/bejne/f4mTtdWLpsvcpso.html
Great 👍 but very long DAX 😢
Do you provide any online [owerbi cpurse ?
@GoodlyChandeep
2 ай бұрын
Goodly.co.in/products
How would this work for by weeks? There is no EOweek function
@GoodlyChandeep
11 ай бұрын
Just add a week number column in your calendar table. Rest of the things in DAX will change accordingly.
@roberttyler2861
11 ай бұрын
@@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
Sir if possible make in Excel sheet also sir💐💐
@DataDashPro
6 ай бұрын
if you want you can look to excel version of same chart here.kzread.info/dash/bejne/f4mTtdWLpsvcpso.html
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.
How can I make this work with Weeks instead of months??
@GoodlyChandeep
2 ай бұрын
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.
How to calculate Period Range?
@DataDashPro
6 ай бұрын
if you want you can look to excel version of same chart here.kzread.info/dash/bejne/f4mTtdWLpsvcpso.html
ERROR BARS IS NOT IN THE POWERBI FORMAT IN JULY VERSION
@DataDashPro
6 ай бұрын
if you want you can look to excel version of same chart here.kzread.info/dash/bejne/f4mTtdWLpsvcpso.html
can't download the file, the link is not working...
@GoodlyChandeep
4 ай бұрын
goodly.co.in/wp-content/uploads/2023/06/Creative-Line-Chart-in-Power-BI.zip
Your T-shirt has some printed characters that distracted throughout the video.
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!!
Heyy, is it just me or video quality is actually not OK?
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)