How to create Line Chart to compare Sales of Multiple Years in PowerBI | MI Tutorials

[@brentc2314]

perfectly done, i cannot believe how many sites etc requiring complicated DAX formulas etc. so much better!

[@felipepinillaramirez2085]

Man, finally someone had the answer!! Took me a lot of “fancy complicated” videos to finally find the right one. Thank you so much! 🙏🏼

[@VamsiKrishna-c7c]

Thanks, Approach is quite simple. I am trying to achieve the filter to this visual, to show only last 1month, 3month,6months etc. In that case its showing only 2023 data and not 2022 data.

[@ritenderchauhan3846]

This was great, I was struggling to get this done, and I tried different methods, but was getting the results. Thanks

[@MITutorials]

Glad it helped!

[@SenpaiMD]

thank you sir, may you have a good day. I had to drill up once on my chart to finish the tutorial but I figured it out.

[@nalakasampath835]

Hi, I really appreciate your tutorial. When I do this in my PC I have faced issues like I could not viewing "Show next level" option. The Power BI app version of my PC is 2.114.864.0 64-bit (February 2023). Please help me asap.

[@daemperador123]

Most simple way I found to do this, thanks for this

[@MITutorials]

Glad it helped

[@Abtinss]

Excellent video. Short and sweet. Thank you :)

[@MITutorials]

Glad it was helpful!

[@SarakshiChandna]

This doesn't work if we want to show for eg investment on secondary axis as bar chart and impressions as line graph trending YoY. Is there another way to do it?

[@forge-squiggler]

Mad Respect! This is exactly what i wanted, and in a quick, understandable manner. Thanks!

[@idolsensei7]

Hello have a question. I have a data for 2021 and 2022. Say If I filter to Feb, the line chart will show all data from Feb 2021up to Feb 2022 so its not a comparison it like a continuous line chart just to show the trend from Feb 2021 to Feb 2022, is thay possible?

[@MITutorials]

Dropping a Tutorial tomorrow morning 10AM IST

[@samarkauser681]

Can you please show me how we can start this graph from April onwards (fiscal year trend)? Specifically for this type of line graph.

[@MITutorials]

Watch this How to Sort Months by Fiscal Months in PowerBI | MITutorials kzbin.info/www/bejne/nV6nenZ5pLanbck

[@MoonShine-bs6cl]

What if in line chart line are overlapping with data labels.. That time we will not b able to see it so clearly right, pls make a video of line chart of cumulative values for 3 years and is it possible to achieve this result.... Thanks in advance

[@harrogatetown12345]

You're a GOD thanks so much! :)

[@rafaelmbsx]

is it possible to do this showing the daily value of sales?

[@MsHalpinFrayser]

can you do this with web version ?

[@ajaypanchal8844]

How can I show two continuous column on x axis with same scale range?

[@parkashkumar-zi8sj]

how to show this graph in fiscal year like my graph should start from July not January. I want to show July 2021 to June 2022 then July 2022 to June 2023 and so on.

[@jagank7812]

Thanks a lot, was very helpful

[@MITutorials]

Glad it helped!

[@jacqueshollands5630]

Thank you very much

[@ankitsrivastava4217]

Can we add percentage trend

[@MITutorials]

Yes! Use custom labels to do that ! Create a Measure and use that as a Data Label in your visuals in Power BI | MiTutorials kzbin.info/www/bejne/f2mYe32IYtGWa6s

[@LuisZepeda-i9w]

Awesome video, thank you

[@carolinaurena7424]

great video Thank you! Saved my life! :)

[@leonardonava1490]

thank you so much

[@hashimsalim3944]

Well done, I really benefited alot from this video. Keep up with the good work :)

[@dollysiharath4205]

The GUI looks different, and it's not working on the updated Power Bi.

[@sonpurkesone4072]

How can show segment or process wise

[@sagarvarandekar8279]

Hi, I want to do the same but compare sales values of two fiscal years. Please suggest a way to do that. I want to do it at my work and it's urgent

[@MITutorials]

Use the same logic as in this video but sort the months by your fiscal month. Watch the below tutorial to see how to do that. How to Sort Months by Fiscal Months in PowerBI | MITutorials kzbin.info/www/bejne/nV6nenZ5pLanbck

[@jorgevillanueva2706]

Coud a Secondary value be added?

[@MITutorials]

Yes it should work with secondary values as well.

[@futairimasu]

Thanks for the video! Really appreciate it

[@yehaipakistan6210]

Amazing, thank you so much !!

[@kcchif8897]

How come my line graph doesn’t show values option?

[@Carolg99]

mine either! did you figure this out?

[@jeromemajahonyenuga9532]

Brilliant

[@eska3389]

Perfekt. Thank you!!

[@javidanalayi3984]

Amazing!

[@luisquinta5290]

good stuff

[@suyeshanavle8909]

I don't get the "Show next level" option

[@LeMax19]

For myself, I couldn't see it either, but I clicked on "Drill up" instead, then right-click again and "Show next level" appeared.

[@geoguy29]

@@LeMax19thanks:)

[@sawravyadav402]

@@LeMax19where is drill up bro 🥹

[@zachsteingas6636]

@@LeMax19 I have spent the last two days looking for the answer to this. Thank you SOOO much

[@selesxavier9580]

​@@LeMax19 I got 'show next level' after doing the drill up. But I was comparing 4 years. And these 4 are coming next to each other. Not together. Is there anything I can do to fix it.thanks

[@likejv]

Same for ytd

[@PeteMaverickMitchell87]

Video fails to explain how dots of data are connected with lines.