Make an Incredible Finance KPI Dashboard with Power BI in 20 minutes

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 พ.ย. 2024

ความคิดเห็น • 147

  • @chandoo_
    @chandoo_  7 หลายเดือนก่อน +2

    🏆Participate in my Dashboard Competition 👉 bit.ly/3xgC1WB

    • @Bloging-yadav
      @Bloging-yadav 3 หลายเดือนก่อน +1

      if you are don't make right video.. that you don't upload wrong video.

  • @sudhakarnote
    @sudhakarnote 7 หลายเดือนก่อน +12

    Congrats for being mentioned in the top Excel youtubers list in the world

  • @anniebannie221
    @anniebannie221 6 หลายเดือนก่อน +3

    Someone suggested me this channel and I cant thank him enough for this recommendation. words fall short.

  • @vedhaprakash164
    @vedhaprakash164 7 หลายเดือนก่อน +19

    Hello chandu , I am really excited to take excel course but due to price 247$ is very much high , can reduce for price for university students , hoping you could reply on these , and thanks for giving datasets for SQL sessions ,

    • @Vivasvan22-21zy
      @Vivasvan22-21zy 7 หลายเดือนก่อน

      Hi bro if you're interested I can provide videos only for 1k all power bi+ssas+azure

  • @CairgyMmapetla
    @CairgyMmapetla 7 หลายเดือนก่อน +6

    In all my time of learning on TH-cam, i have never got so much in 20 minutes its crazy 😅 Like. Thank you!

  • @guenzizabdelaziz5185
    @guenzizabdelaziz5185 2 หลายเดือนก่อน

    Hi Chandoo.
    All your Trainings are Very interesting. You make a lot of effort to prepare them; which gives videos with good quality . You are using a very good and simple teaching. Thank you.

  • @adrianagonzalez9951
    @adrianagonzalez9951 4 หลายเดือนก่อน +1

    I definitely felt in love with the report despite not meeting the targets. Please show us how you made it look more beautiful at the end

  • @shilpa2606
    @shilpa2606 หลายเดือนก่อน

    Hi Chandoo, I was your channel following for months now and your videos are very useful. How can we use measures in a new measure as in the above dashboard i can't add Variance when creating Months target reached measure. If you can reply it would be very helpful. Thanks.

  • @kuuuyajim
    @kuuuyajim 7 หลายเดือนก่อน +2

    You make dashboards like a walk in the park.

  • @AjayKumarparmar
    @AjayKumarparmar 3 หลายเดือนก่อน +1

    can we shrink the size of last visual which has months showing if target met or not having red and green colors...the column visual that you have put out there. if i shrink the width of it, few months are being hidden. any way dear Chandoo to still keep them showing...

  • @lilyfullery4779
    @lilyfullery4779 6 หลายเดือนก่อน +2

    Hi Chandoo , i feel variance should be Calculated as Total_Target - Total_Actual
    because target is what needs to be acheived and actual is what has been achived.

    • @chandoo_
      @chandoo_  6 หลายเดือนก่อน +2

      In that case, you will get a positive variance when we do not meet the target. As positive numbers indicate good outcomes, the logic needs to be actual-target.

  • @Rashid-qz7pt
    @Rashid-qz7pt 6 หลายเดือนก่อน +2

    Hi Chandoo! When you choose an individual sales person at 20:40 you get Month Target Reached = 7, however the little chart below clearly shows smth different, besides above it says 'we met targets 2 out of 14 month. How could we fix that?

    • @swetaleenasatpathy6125
      @swetaleenasatpathy6125 6 หลายเดือนก่อน

      Hi, you can fix this issue by changing the bar/column charts to line charts. Line charts are perfectly filtering out data for individual salesperson. I am yet to figure out the reason.

  • @mvshyamprasad09
    @mvshyamprasad09 6 หลายเดือนก่อน +2

    Why I am getting difference in some values from what you got and what I got using the same method?

  • @HenriquedeAlbuquerque-x1x
    @HenriquedeAlbuquerque-x1x 6 หลายเดือนก่อน +1

    thank you so much for the content you have been posting on TH-cam Channel. May I suggest/ask something? Can you please teach us how to create a multilanguage Dashboard in Power BI?
    I have been looking for something on Google, and TH-cam and so far I couldn't find anything. Please, can you help me with this?

  • @sportswind2569
    @sportswind2569 2 หลายเดือนก่อน +2

    Wonderful video but i have a question on i am unable to get the ytd sales actual, ytd variance, ytd variance % , ytd sales target. Please answer my question i am unable to proceed forward.

    • @chandoo_
      @chandoo_  2 หลายเดือนก่อน

      Why are you unable to get them? The clues and example is already shown in the video.

    • @kikis7680
      @kikis7680 หลายเดือนก่อน +1

      ytd sales target formula, ytd variance , ytd variance % is missing in the vvideo

    • @kikis7680
      @kikis7680 หลายเดือนก่อน

      ​@@chandoo_help

  • @michaelmaharlika8569
    @michaelmaharlika8569 7 หลายเดือนก่อน +2

    I am very impressed, outstanding job on tis dashboard. Thank you for being you, and for your creative and intuitive insight in to telling stories with data!

    • @chandoo_
      @chandoo_  7 หลายเดือนก่อน

      Wow, thank you!

  • @Malarvizhi.S-kc5dq
    @Malarvizhi.S-kc5dq 6 หลายเดือนก่อน +1

    Hi Chandooo Anna,
    I have reached till dax function - target for the month, but I am not getting any expected value, it results this _ _ and there are no errors in the formula. Can you please help me rectify this?

  • @vijaychauhan5447
    @vijaychauhan5447 7 หลายเดือนก่อน +3

    Sir Namaste
    Your All videos very knowledgeable.

  • @sanjeecodes2722
    @sanjeecodes2722 17 วันที่ผ่านมา

    Hello Chandoo Bruh , I have a query regrading Months Target Reached Formula , Variance didnt comes in option .will i create a Dax Calculation . Kindly Sort Out this

  • @theMilgarStudio
    @theMilgarStudio 7 หลายเดือนก่อน +6

    Hi Chandoo, when am creating the visual for measure YTD actual, am getting card visual as " Blank ". Could you please help me with this? Hope the measure is right! : YTD sales actual = CALCULATE([Total sales actual], DATESYTD('Calendar'[Date]))

    • @michelcockerham2109
      @michelcockerham2109 7 หลายเดือนก่อน

      me too!

    • @talknow2859
      @talknow2859 6 หลายเดือนก่อน

      Me too!

    • @nganpham8431
      @nganpham8431 5 หลายเดือนก่อน

      me too! can anyone help me to resolve??

    • @na-zw8ju
      @na-zw8ju 5 หลายเดือนก่อน +4

      This youtuber cut a lot of important moments. If you get stuck for this, in "Actual", change the data type of the "Date" column from Text to Date.

    • @nganpham8431
      @nganpham8431 5 หลายเดือนก่อน

      @@na-zw8ju Thank a lots. can resolve it now

  • @guedidzineb8714
    @guedidzineb8714 7 หลายเดือนก่อน +1

    Hello, I hope you are well. I am a student. I need help with the decision support system. I am looking for training in this subject. Is it a requirement to understand the ssis ssas ssrs program or Power Bi just to implement my graduation project?

  • @tjoelgeorge
    @tjoelgeorge 7 หลายเดือนก่อน +1

    Hi Chandoo, thanks for the video, certain steps of the video have been removed, would have been better if those also were included. Anyways thanks for the video

  • @shankardevkota3577
    @shankardevkota3577 6 หลายเดือนก่อน +4

    HI chandoo, in minute 8, YTD Sales Actual = CALCULATE([Total Sales Actual], DATESYTD('Calender'[Date]), this formula didnt work in my case? 'Total Sales Actual' didnt read by CALCULATE function. however it was working fine in previous formulas. Please help me with this. Thank you.

    • @Hercules90015
      @Hercules90015 5 หลายเดือนก่อน +1

      Yes, I am also facing same issue

    • @krantikumarm2705
      @krantikumarm2705 3 หลายเดือนก่อน

      @@Hercules90015 same

    • @ambernaz6793
      @ambernaz6793 3 หลายเดือนก่อน +1

      @@Hercules90015 were you guys able to solve it? this formula is not working for YTD target, variance, and %variance.

    • @arindamsarkar123
      @arindamsarkar123 2 หลายเดือนก่อน

      @@ambernaz6793 same here

  • @arbazahmad7177
    @arbazahmad7177 7 หลายเดือนก่อน +3

    Excellent.... thanks for sharing 👍

  • @chrism9037
    @chrism9037 7 หลายเดือนก่อน +1

    This was great, thanks Chandoo!

  • @judeLondon
    @judeLondon 7 หลายเดือนก่อน +1

    Beautiful despite missing targets So fun. So clean. So clear

  • @vaishaliniramakrishnan6241
    @vaishaliniramakrishnan6241 7 หลายเดือนก่อน +1

    What is the DAx to be used to get previous month

  • @kavitadaga6689
    @kavitadaga6689 7 หลายเดือนก่อน +1

    I love how this video is challenging a beginner like me to figure out nuances instead of spoon feeding every step. I managed to solve most of my problems, but somehow months target reached is still 0 and my column chart for target vs actual sales shows no data for any of the in between months. Why?

    • @kavitadaga6689
      @kavitadaga6689 7 หลายเดือนก่อน

      Ok, got a part of the answer - it is treating the dates as in mm/dd/yyyy format!

  • @taofeekogunsesu2566
    @taofeekogunsesu2566 7 หลายเดือนก่อน +2

    You are very good. Thank you for so many information in a very short time.

    • @adrianagonzalez9951
      @adrianagonzalez9951 4 หลายเดือนก่อน

      That's what set him apart from other youtubers!

  • @jayaprakashh2604
    @jayaprakashh2604 7 หลายเดือนก่อน +1

    Hi Sir,
    I it’s helpful I learned lot from your video I would like to request your all data shows only about sales data if you can do some dashboard with supply chain and inventory management data it will be helpful for other professionals.
    It’s just request.
    Thank you 🙏🏻

    • @chandoo_
      @chandoo_  7 หลายเดือนก่อน

      Noted

  • @sandhyacp4070
    @sandhyacp4070 8 วันที่ผ่านมา

    Incredible!! Thanks lot for this video Sir!

  • @Bloging-yadav
    @Bloging-yadav 3 หลายเดือนก่อน +1

    Hi chandoo
    if I am calculate -- Variance = [Total Actual Sales] - Targets[Total Sales Target] how to get variance in Positive value that is Impossible because your Actual sales = $1,89,49,239 and Target is $1,93,16,100 and your variance % is also wrong.. Can you proved that

  • @alokupadhyay3732
    @alokupadhyay3732 4 หลายเดือนก่อน +1

    hey man , can you give formula for YTD VARIANCE, YTD VARIANCE %, AND YTD SALES TARGET

  • @Sirigineedi_Navann
    @Sirigineedi_Navann 7 หลายเดือนก่อน +1

    simply fantastic anna
    Happy Ugadi anna

  • @PONCEJE
    @PONCEJE 7 หลายเดือนก่อน +1

    Nice smile congratulations. You looks fantastic.

  • @mohemmedansari8664
    @mohemmedansari8664 7 หลายเดือนก่อน +1

    You make it easy and cool.

  • @sam02109
    @sam02109 6 หลายเดือนก่อน +1

    Hi Chandoo, YTD Sales Actual = CALCULATE([Total Sales Actual], DATESYTD('Calendar'[Date]), this formula didn't work in my case. 'Total Sales Actual' didn't read by CALCULATE function. however, it was working fine in previous formulas. Please help me with this.
    YTD Variance % is also showing -100%.
    Thank you.

    • @krantikumarm2705
      @krantikumarm2705 3 หลายเดือนก่อน

      i have also same probelm

    • @Bloging-yadav
      @Bloging-yadav 3 หลายเดือนก่อน

      It is working now YTD Sales Actual = CALCULATE([Total Actual Sales], DATESYTD('Calendar'[Date]))

  • @AchuVlogs
    @AchuVlogs 7 หลายเดือนก่อน +1

    Excellent dashboard sir!!

  • @PONCEJE
    @PONCEJE 3 หลายเดือนก่อน

    You are the best. Thanks

  • @ugochukwunwasuruba1356
    @ugochukwunwasuruba1356 2 หลายเดือนก่อน

    This is so good
    Amazing dashboard

  • @zaidandhman7687
    @zaidandhman7687 5 หลายเดือนก่อน +1

    can you please make a video to explain time intelligence functions in details

  • @ashwinikumar2302
    @ashwinikumar2302 หลายเดือนก่อน

    This is just awesome. Thank you Sir.

  • @vishwanathm4207
    @vishwanathm4207 6 หลายเดือนก่อน

    Hi @Chandoo Sir,
    I'm a Power Bi developer with 4+ yrs exp
    My Skills
    SQL, Power BI & Knowledge on Tableau
    Please suggest me additional course which will enhance my career Growth.
    Currently I'm in middle of learning Power of APPS & Automate, Shall I learn this ADF & Python Stuff or Power Platform?

  • @dhaval1489
    @dhaval1489 7 หลายเดือนก่อน +1

    Chando Bhai, can you please do a time series analysis in Power BI it seems quite complicated

  • @ashutoshdas7534
    @ashutoshdas7534 หลายเดือนก่อน

    < Actual
    Column 'Sales Person' in Table 'Actual' contains a duplicate value 'Andria Kimpton' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
    Targets
    Load was cancelled by an error in loading a previous table. > i got this error after data cleaning . what should i do?

  • @mistertechstudio
    @mistertechstudio 3 หลายเดือนก่อน

    Chandoo ji your competition requires in depth knowledge.

  • @Nxomirblx
    @Nxomirblx 3 หลายเดือนก่อน

    Hi Chandoo, Im not getting Total sales actual= Sum(actual [sales]) it is not showing sales

  • @shaguftanighat-de3sj
    @shaguftanighat-de3sj 7 หลายเดือนก่อน +1

    Hello, Chandoo Brother, you skip two formulas 1. YTD Variance 2. YTD Variance % during editing the video so I Can't understand it. Please tell me how can I calculate these formulas? Because I am beginner.

  • @manikantakollection5407
    @manikantakollection5407 4 หลายเดือนก่อน

    Hii sir if the data is load it's showing error in actual sales andria. Kimpton and this not allowed for columns on the one side of a many to one relationship or for columns that are used as the primary key of a table. Ani vasthundhi sir em cheyyali ippudu

  • @abdullahusman4539
    @abdullahusman4539 7 หลายเดือนก่อน +1

    Thanks bro for making this video

  • @fahimreza2009
    @fahimreza2009 7 หลายเดือนก่อน +1

    Excellent!

  • @zaidandhman7687
    @zaidandhman7687 5 หลายเดือนก่อน

    when I changed the date data type after unpivoting the columns, it gives me wrong dates ( all the dates year were 2024) , this affect the time intelligence function hence there is no year but the year 2024... how I can fix that….. please advise

  • @abimanyuramadani4174
    @abimanyuramadani4174 3 หลายเดือนก่อน

    How to change date target and actual on google sheet source data?
    I try to change date to another date, that shoe error "The column "01/09/2024" the table wasn't found"
    Thaks for help

  • @MuhammadAli-ib4xn
    @MuhammadAli-ib4xn 7 หลายเดือนก่อน +1

    Helpful thanks so much

  • @AbishekS-zn7qy
    @AbishekS-zn7qy 3 หลายเดือนก่อน

    Chandoo i had a doubt in the 'Month Target Reached' though i used the correct dax measure like you ,it results 14 but it's actually 2, please solve my issue anyone!

    • @chandoo_
      @chandoo_  3 หลายเดือนก่อน

      The number you see depends on the filter / evaluation context. Make sure you are not filtering something out and have used the dax as demoed in the video.

    • @ambernaz6793
      @ambernaz6793 3 หลายเดือนก่อน

      @@chandoo_ what a dumb excuse. Say it Chandoo, you yourself don't know.

  • @pragyawasthi
    @pragyawasthi 3 หลายเดือนก่อน

    I'm not able to find the link for data set. Can anybody help me ?

  • @murlidhartiwari162
    @murlidhartiwari162 4 หลายเดือนก่อน +1

    Please create advanced level power bi financial dashboard for financial planning and analysis domain covering income tax statement, cash flow, variance and ratio analysis OR some banking detail dashboard covering total disbursement count, value and sanction count and value, total aum(asset under management), gross income, ltv%, bounce rate,ROI%

  • @emmanueloladipojohnson890
    @emmanueloladipojohnson890 7 หลายเดือนก่อน

    Do you have a beginner video on Power BI and DAX formula?

    • @chandoo_
      @chandoo_  7 หลายเดือนก่อน +1

      I do. Check this - th-cam.com/video/PQ5lALdFHCU/w-d-xo.html

  • @eslamhatem5735
    @eslamhatem5735 3 หลายเดือนก่อน

    I'm very impressed ❤❤

  • @pogulasai3930
    @pogulasai3930 7 หลายเดือนก่อน

    Hai chandoo Anna, when I have unpivoted other columns and shriked the remaining columns to date and sales and when I tried to load the data I am getting an error: "Column 'Sales Person' in Table 'Actual' contains a duplicate value 'Andria Kimpton' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table."
    Please Help

    • @chandoo_
      @chandoo_  7 หลายเดือนก่อน

      The tables Actual and Targets have no direct relationship. The relationships are between
      Actual - calendar
      Actual - sales person
      Target - Calendar
      Target - sales person

  • @mdshahnwaz5853
    @mdshahnwaz5853 7 หลายเดือนก่อน

    Question- Why the dashboard showing wrong while filtering individual team like Tempo team showing 4 months out of 14 months however if see count the green variance column that only 3 on top of it.

    • @chandoo_
      @chandoo_  7 หลายเดือนก่อน

      In my case, it shows 4 green bars and says 4 out of 14 months. So may be you have a horizontal scrollbar on the graph?

    • @mdshahnwaz5853
      @mdshahnwaz5853 7 หลายเดือนก่อน

      @@chandoo_ Thank you for replying, no I'm taking about in your dashboard please count the column which is labels as green percentage% on top like team Temp I can see there only 3 column which mentioned green percentage for variance surpass vs
      target sales, also I know their in-card visuals 4 months showing which is fine, please suggest if understanding something incorrect.

    • @chandoo_
      @chandoo_  7 หลายเดือนก่อน

      Not sure what you mean. If it is shown in the video, can you share the timestamp so I can examine further.

    • @thes6z810
      @thes6z810 7 หลายเดือนก่อน

      Ya sure here is the time which is Team "Tempo" filter 17:48 see the top where header title is we met target 4 out of 14 however count the month column which lebels as green🟢 Dot % that is only 3 why that should be 4 because that's 🟢lebel showing we reached the target sales value

    • @chandoo_
      @chandoo_  7 หลายเดือนก่อน

      That is because of label density. Power BI automatically hides labels when they are too many of them. It just shows labels for important points. You can adjust the density to 100% (thus showing all labels all the time). By default it auto-hides labels for some points.

  • @swetaleenasatpathy6125
    @swetaleenasatpathy6125 6 หลายเดือนก่อน

    Hi Chandoo, please do reply to my query. Why is the whole dashboard behaving weirdly when filtered with salesperson name?

    • @chandoo_
      @chandoo_  6 หลายเดือนก่อน

      Hmm.. nothing unusual there. When you select a salesperson (in the table), all visuals are showing the values for that salesperson. Are you seeing any wrong values?

    • @swetaleenasatpathy6125
      @swetaleenasatpathy6125 6 หลายเดือนก่อน

      @@chandoo_ somebody else (Rashid-7z..) has also commented regarding the same issue. Column chart title is not getting updated dynamically, columns are looking weird and the little chart below all the KPI cards is also not showing the correct values when you select a single salesperson from the table. I replaced both of these charts as Line charts, and they are now showing the correct values for a salesperson. I am unable to figure out the reason behind discrepancies in column charts.

    • @swetaleenasatpathy6125
      @swetaleenasatpathy6125 6 หลายเดือนก่อน

      @@chandoo_ When we filter the dashboard by selecting a single salesperson from the table, the little chart below the KPI cards is showing some really weird bars, also the column chart gets distorted completely. The chart heading does not get dynamically updated as well. I replaced all the column charts with line charts and then everything is working as expected. I am unable to figure out the reason behind this. There is another comment by
      @Rashid-qz7pt highlighting the same issue.
      You can also check your video from 20:36 mins. I can see the same issue.

    • @chandoo_
      @chandoo_  6 หลายเดือนก่อน

      I think this is a highlighting "bug" in Power BI when CF rules are also used. That is why our tiny win/loss chart is showing weird colors (the columns are right) when clicking on a person.
      Reg. chart title not chaging, that is expected. As we have the interaction set to "highlight" rather than "filter", the title won't change. When you use a line chart, it always "filters" so, the title changes. Everything else is as per normal behavior, but might seem strange if you are not used to seeing such interactions.

  • @ibrahim82649
    @ibrahim82649 7 หลายเดือนก่อน +1

    Nice one Chandoo

  • @Samyaksingh-s7c
    @Samyaksingh-s7c 3 หลายเดือนก่อน

    How did you got M in the sales data, mine is just showing number

    • @chandoo_
      @chandoo_  3 หลายเดือนก่อน

      Power BI automatically shows it.

  • @rajishn
    @rajishn 7 หลายเดือนก่อน

    my win loss chart is all showing 1 and all in green.. what could be the reason

  • @Amathylar
    @Amathylar 7 หลายเดือนก่อน

    Do you make custom dashboards? I want one for my business!

    • @indrajaravi6945
      @indrajaravi6945 7 หลายเดือนก่อน

      I know someone who makes custom Power BI Dashboards for businesses. He has helped businesses 2x their revenue! Let me know if you'd be interested.

  • @GautamJoshi-nx3nh
    @GautamJoshi-nx3nh 5 หลายเดือนก่อน

    why in my hand YTD returns blank

  • @srinivaskorada2919
    @srinivaskorada2919 16 วันที่ผ่านมา

    Hi chandoo, Can I have this data set pls.

  • @pgkannan
    @pgkannan 7 หลายเดือนก่อน +1

    Happy Ugadi

  • @vijaychauhan5447
    @vijaychauhan5447 7 หลายเดือนก่อน

    Sir Can you Make market stock portfolio report in Excel by Google finance.

  • @godisalmighty4449
    @godisalmighty4449 7 หลายเดือนก่อน

    Great. Thnks a lot sir

  • @nickcanque9106
    @nickcanque9106 7 หลายเดือนก่อน

    I'm having problem with my output for
    YTD Sales Actual, YTD Sales Target, YTD Variance, YTD Variance % showing - -
    YTD Sales Actual = CALCULATE([Total Sales Actual],DATESYTD('Calendar'[Date]))

    • @tjoelgeorge
      @tjoelgeorge 7 หลายเดือนก่อน +5

      Hello Nick, please use the following
      YTD Sales Actual = CALCULATE([Total Sales Actual], DATESYTD(Actual[Month]))
      YTD Sales Target = CALCULATE([Total Sales Target],DATESYTD(Targets[Month]))
      YTD Variance = [YTD Sales Actual]-[YTD Sales Target]
      YTD Variance % = DIVIDE([YTD Variance],[YTD Sales Target])

    • @nickcanque9106
      @nickcanque9106 7 หลายเดือนก่อน

      @@tjoelgeorge tnx

    • @michelcockerham2109
      @michelcockerham2109 7 หลายเดือนก่อน

      @@tjoelgeorge When I do this, I get an error message.
      Any ideas why?

    • @talknow2859
      @talknow2859 6 หลายเดือนก่อน

      ​​i did the same and was prompted to format the the date tables to date type. Then youll get the right answer.@@michelcockerham2109

  • @shankirianilgoud1930
    @shankirianilgoud1930 7 หลายเดือนก่อน

    Hello chandu
    Naaku power bi full course kavali Ela please response

    • @chandoo_
      @chandoo_  7 หลายเดือนก่อน

      Please visit chandoo.org/wp/power-bi-course and sign up

    • @shankirianilgoud1930
      @shankirianilgoud1930 7 หลายเดือนก่อน

      @@chandoo_ replying chesinanduku chala thanks Anna garu I am from Telangana

  • @dikkhatrainingconsultancy8526
    @dikkhatrainingconsultancy8526 7 หลายเดือนก่อน

    If I don't use Var and write directly this formula COUNTROWS(FILTER(all('Calendar'),[Variance]>0)), It is still working. Why Var is required in this case

    • @chandoo_
      @chandoo_  7 หลายเดือนก่อน +1

      You can do that too. I like using variables so that my DAX looks better and lets me add conditions easily later.

    • @dikkhatrainingconsultancy8526
      @dikkhatrainingconsultancy8526 7 หลายเดือนก่อน

      @@chandoo_ thanks for your reply

  • @Saurabh-gh7ym
    @Saurabh-gh7ym 7 หลายเดือนก่อน

    hey chandoo in the video the actual has only three columns but in reality there are 14 columns
    how am i supposed to make relationships same as that on the video?? please help u skipped that part

    • @chandoo_
      @chandoo_  7 หลายเดือนก่อน

      Hmm.. I explain that step in the data prep part. You need to unpivot both actual and target tables.

    • @a-31saurabhghore46
      @a-31saurabhghore46 7 หลายเดือนก่อน +2

      Got it thanks man loved the tutorial

  • @SyedliyakathaliAli
    @SyedliyakathaliAli 7 หลายเดือนก่อน +1

    Fantastic video chandoo❤🎉

    • @chandoo_
      @chandoo_  7 หลายเดือนก่อน

      Thanks 🤗

  • @sowmyav5878
    @sowmyav5878 7 หลายเดือนก่อน

    Hi sir, how to create YTD variance. Can u plz explain

    • @chandoo_
      @chandoo_  7 หลายเดือนก่อน +2

      Assuming you have already calculated YTD Actuals and YTD Targets,
      YTD Variance = [YTD Targets] - [YTD Actuals]
      To calculate YTD Actuals, use this logic:
      =CALCULATE([Total Actuals], DATESYTD(Calendar[date]))
      Same pattern for the YTD Targets too.

    • @nitinsharma2019
      @nitinsharma2019 7 หลายเดือนก่อน

      ​@@chandoo_The video should be in a simple form so that beginners can learn from it as well

    • @chandoo_
      @chandoo_  7 หลายเดือนก่อน

      Come on mate. You can't expect a beginner to straight away make a dashboard. Take baby steps with other videos. I have plenty that go slow and explain all the basics. If in every video, I open by saying now start your computer and download Power BI then no one would watch.

  • @harshithharsha4066
    @harshithharsha4066 5 หลายเดือนก่อน

    tables are not connecting

  • @thunder6179
    @thunder6179 7 หลายเดือนก่อน +1

    Sir please do a videos kn informatica

  • @NamrataGuru
    @NamrataGuru 7 หลายเดือนก่อน +1

    make vdo including copilot in BI

  • @BarshaD062
    @BarshaD062 5 หลายเดือนก่อน

    Hi could anyone help me, after adding YTD Sales Actual data into Reference label Series for all the 5 labels I'm getting same value as YTD Sales Actual $2M

    • @chandoo_
      @chandoo_  5 หลายเดือนก่อน

      You need to set the label individually to each item.

    • @BarshaD062
      @BarshaD062 5 หลายเดือนก่อน

      ​@@chandoo_ Hi, Chandoo. Yes, I have done that. In all five categories, I'm getting the same figure as YTD Sales Actual $2M.

    • @chandoo_
      @chandoo_  5 หลายเดือนก่อน

      Check the measure logic. Test by first making a card with all 5 values.

  • @KiranKumarArachepalli
    @KiranKumarArachepalli 2 หลายเดือนก่อน

    Hi Chandoo. how are you? are you available now?

  • @rohanbhoi3244
    @rohanbhoi3244 26 วันที่ผ่านมา

    can you share this dashboard

  • @kunalsyal3658
    @kunalsyal3658 2 หลายเดือนก่อน

    nice tshirt

  • @mohdimroz2769
    @mohdimroz2769 5 หลายเดือนก่อน

    sir images not work 😢

  • @priyanshujha2737
    @priyanshujha2737 3 หลายเดือนก่อน

    why my month TARGET REACH IS 14😐

  • @kaleemulhassan2841
    @kaleemulhassan2841 4 หลายเดือนก่อน

    How is your variance $367k when both actual and target sales is $19m 😳

  • @allison447
    @allison447 4 หลายเดือนก่อน

    Chandoo! Are you here?

    • @chandoo_
      @chandoo_  4 หลายเดือนก่อน

      Yes... how can I help?

  • @VekashKUMAR-m9o
    @VekashKUMAR-m9o 6 หลายเดือนก่อน

    too fast ... Dax fn are not explained

  • @AbdulAhad-wy3hi
    @AbdulAhad-wy3hi 4 หลายเดือนก่อน

    1) When I connected my Calendar to Actual, it did not automatically connected it to Target one like yours did. Why?
    2) Unable to make further YTD measures for references or of possible results are different. Have tried multiple times in new measure
    Hence left the video in the midst because of (2). No point of moving forward when not getting it