🙋 bro your videos are very helpful 👍 I have some doubt : I think for MOM% the calculation would be Divide( CurrentMonth - PreviousMonth / PreviousMonth ) instead of Vairance - PreviousMonth ? & I want to know that you have done 13 videos of ADF is it enough to get entry level job.....
Hi @Mahesh717, Yes, you are correct it should be Divide( CurrentMonth - PreviousMonth / PreviousMonth ). Regarding ADF videos, It may not be sufficient but definitely a good way to start. Thank you for watching!
When i add the verince it summrozed by sum so the % not reflected right i tried to change it to non summrized but it is not availbe it mandatory to selcet one choice sum ,avg ,medin ,, how i can fix this issue
I'm trying to create a visual to compare units sold in one month to the same month the prior year, I think this will work if I adjust the interval in the measure. Would slicers work to add skus and variations so I can focus on certain products or groups? I found the video helpful and easy to understand thanks!
Hi, That's interesting, let me try.I will share my findings with you soon. Mean while if you can provide sample data to replicate exactly the same issue your facing will be better.
Hi @Namita, Based on date column, first you can create a Week number column using WEEKNUM Dax. Then based on this you should able to proceed for further calculation. Thank you for watching.
Hi , thanks for your detailed video. I created the same chart with latest 12 months comparison with previous year , While hovering the above bars for Current year Month bar and previous year month bar , what if i need to show the light blue bar as 2012 while hovering on the light blue bar and when hovering on the Dark blue it should show hover the values as 2011. Could you pleas suggest. For now while hovering both the bars show as same N0V-2021 as i have taken by x-axis with MMM-YY.
When compare month, how can I add two dropdown allow me to choose which two months I would like to compare with. for example, Jan vs June instead of June compared to last month only Thank you
Hi @PL, sorry for the delayed response. You can try below two approaches which ever satisfy your requirement- 1) Try horizontal month slicer with multiple selection option. So if you'll select two any two months graph will show data for only those months. 2) Try creating copy two similar charts and two month slicers. With help of edit interaction limit the interaction of each slicer to one chart only. Now you can format both chart in same look and feel. Add some comments which will prompt user to select months in both slicers to compare with each other. Lets me know if it worked Or if you have already did it with better solution. Thank you!
Hey, I've try your formula but my dashboard can't show the previous value probably because my date data is not continuous (updated only once per month, for example date input on 01/01/2022 next data will be on 01/02/2022). Any suggestion to solve this? It's work well only if using Year or Quarter date hierarchy.
It should work well even if there is any single date of any month. As a workaround try creating a Date table; connect the date table with the Date column in your main table and then use the date table's date in all related DAX. Also please check "Auto Date & Time intelligence option is on by going into File--Options & setting---Options--Current File--Data Load--"AutoDate/Time". Please let me know if you still face any challenges.
Hi Great video! Do you have any examples where you are comparing a months from the current year and previous year? If I select the year 2022 and month September then it should compare the data between September 2021 and September 2022.
Thank you! we can such view using below process- 1) Create single select slicer for year and month. 2) Create measure for selected value to get selected year and month 3) Create same period last year DAX and use selected year and month value as variable from above DAX, to get the last year/month value. Hope it helps. Thank you!
Hi @Shiva, You can go into format visual section, select column color there you define rules or select gradient color for the columns based on column value. Hope it helps.
Hi Aayush, Thank you for watching. It is not now possible now but in future videos I can make sure to upload a link to dataset too. Mean while there are various open sources from where you can get free data to learn and test your visuals. below are a few- data.europa.eu/en databank.worldbank.org/home.aspx www.data.gov.uk/ Hope it will help! Keep learning!
Hi Manasa! Thank you for watching. It is not now possible now but in future videos I can make sure to upload a link to dataset too. Mean while there are various open sources from where you can get free data to learn and test your visuals. below are a few- data.europa.eu/en databank.worldbank.org/home.aspx www.data.gov.uk/ Hope it will help! Keep learning!
Thanks. It was very easily understandable and smooth while implementing.
Great to hear!
Thank you for the appreciation!
Thank you for the amazing breakdown of this chart VERY INSIGHTFUL!
Thank you for watching. I'm glad it helped.
It's interesting, but the only problem is that I can't see the dax expression you type , you should zoom out the functions so we can follow
Sure!
Thank you for watching! I hope it was helpful.
Fantastic explanation - thankyou.
Thank you!
🙋 bro your videos are very helpful 👍
I have some doubt :
I think for MOM% the calculation would be
Divide( CurrentMonth - PreviousMonth / PreviousMonth )
instead of Vairance - PreviousMonth
?
& I want to know that you have done 13 videos of ADF is it enough to get entry level job.....
Hi @Mahesh717,
Yes, you are correct it should be Divide( CurrentMonth - PreviousMonth / PreviousMonth ).
Regarding ADF videos, It may not be sufficient but definitely a good way to start.
Thank you for watching!
Excellent tutorial! Very helpful!
Thank you!, I'm glad it was helpful!
When i add the verince it summrozed by sum so the % not reflected right i tried to change it to non summrized but it is not availbe it mandatory to selcet one choice sum ,avg ,medin ,, how i can fix this issue
thanks a lot for the wonderful explanation
Glad it was helpful!
I'm trying to create a visual to compare units sold in one month to the same month the prior year, I think this will work if I adjust the interval in the measure. Would slicers work to add skus and variations so I can focus on certain products or groups? I found the video helpful and easy to understand thanks!
Thank You @michele.
I'm glad it helped.
Hey hi in powerbi I want to compare a value for continuous 15 mins if the value is same for 15mins continuously and I need a count 1 for that
Hi,
That's interesting, let me try.I will share my findings with you soon.
Mean while if you can provide sample data to replicate exactly the same issue your facing will be better.
How to show the same period last year's month name as well in bar chart when we hover it?
I have May- Sept customer data in excel and need to make weekly dashboards based on metrics ,How can I approach that
Hi @Namita,
Based on date column, first you can create a Week number column using WEEKNUM Dax. Then based on this you should able to proceed for further calculation.
Thank you for watching.
Hi,here i want to divide previous month sales with previous month number.can advise me how to write with dax formula.thanks
Hi koteswari, You can use variables in the Dax.
var1 sales previous month sales
var2 monthnum = previous month number
return sales/monthnum
it worked well. thank you!
Thank You! @Beulah
Hi , thanks for your detailed video. I created the same chart with latest 12 months comparison with previous year , While hovering the above bars for Current year Month bar and previous year month bar , what if i need to show the light blue bar as 2012 while hovering on the light blue bar and when hovering on the Dark blue it should show hover the values as 2011. Could you pleas suggest. For now while hovering both the bars show as same N0V-2021 as i have taken by x-axis with MMM-YY.
Hi Sunil,
Yes, It is can be done in power BI. We have got options to customize the tooltip.
When compare month, how can I add two dropdown allow me to choose which two months I would like to compare with.
for example, Jan vs June instead of June compared to last month only
Thank you
Hi @PL,
sorry for the delayed response.
You can try below two approaches which ever satisfy your requirement-
1) Try horizontal month slicer with multiple selection option. So if you'll select two any two months graph will show data for only those months.
2) Try creating copy two similar charts and two month slicers. With help of edit interaction limit the interaction of each slicer to one chart only. Now you can format both chart in same look and feel. Add some comments which will prompt user to select months in both slicers to compare with each other.
Lets me know if it worked Or if you have already did it with better solution.
Thank you!
Hey, I've try your formula but my dashboard can't show the previous value probably because my date data is not continuous (updated only once per month, for example date input on 01/01/2022 next data will be on 01/02/2022). Any suggestion to solve this? It's work well only if using Year or Quarter date hierarchy.
It should work well even if there is any single date of any month. As a workaround try creating a Date table; connect the date table with the Date column in your main table and then use the date table's date in all related DAX. Also please check "Auto Date & Time intelligence option is on by going into File--Options & setting---Options--Current File--Data Load--"AutoDate/Time". Please let me know if you still face any challenges.
Hi
Great video! Do you have any examples where you are comparing a months from the current year and previous year? If I select the year 2022 and month September then it should compare the data between September 2021 and September 2022.
Thank you!
we can such view using below process-
1) Create single select slicer for year and month.
2) Create measure for selected value to get selected year and month
3) Create same period last year DAX and use selected year and month value as variable from above DAX, to get the last year/month value.
Hope it helps.
Thank you!
Very insightful. Thanks for sharing your knowledge. Do you think the Y axis Values should be turned off since your chart now includes data labels?
Thank you Arung!
Yes, values can be turned off as bars are showing data labels.
Thank you so much!!!
Glad it helped!
@@AchieversDataEngineering Do you have a video on how to calculate YTD Monthly Average?
How to calculate sales per week without creating new column?
Hi,
It would be easy and better both to have a week column to calculate sales per week.
Thank you for watching!
Thank you ! works like a charm
Hi @Karma, Great to hear this. I'm glad it helped.
How can we give the colouring for data label based on high and low
Hi @Shiva, You can go into format visual section, select column color there you define rules or select gradient color for the columns based on column value.
Hope it helps.
@@AchieversDataEngineering yes it is helpful Thanks for the reply
HI Sir, can you please provide this excel sheet so that I can practice along with the tutorial. Thank you
Hi Aayush,
Thank you for watching. It is not now possible now but in future videos I can make sure to upload a link to dataset too.
Mean while there are various open sources from where you can get free data to learn and test your visuals.
below are a few-
data.europa.eu/en
databank.worldbank.org/home.aspx
www.data.gov.uk/
Hope it will help! Keep learning!
Awesome
Thank you Shoaib!
Keep Learning!
I'm getting incorrect graph.. its not showing 3 bars for 3 years, instead showing the variance between highest and lowest sales between the 3 periods
Thank you for watching!
Please see if you were using correct chart type.
Nice
Thank you Mohit!
thanks
Thank you for watching.
n u pls provide this pbix file
Hi Manasa!
Thank you for watching. It is not now possible now but in future videos I can make sure to upload a link to dataset too.
Mean while there are various open sources from where you can get free data to learn and test your visuals.
below are a few-
data.europa.eu/en
databank.worldbank.org/home.aspx
www.data.gov.uk/
Hope it will help! Keep learning!
Dint understand u used Dax functions
Hi Ss, Which DAX function you could not understand?
👍
Thank you!🙂
you are too fast and you dont explain each step especially for newbies