Thank you for this clear and concise example!! Can you show us how to create a visual for a comparison analysis on spending by different customers over different months? Keeping the percentage/variance change as a visual!
🙋 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!
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.
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
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 @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 @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!
Thx for this video it was very easy to understand
You're welcome! I'm glad it was helpful.
Thank you for the amazing breakdown of this chart VERY INSIGHTFUL!
Thank you for watching. I'm glad it helped.
Thank you for this clear and concise example!! Can you show us how to create a visual for a comparison analysis on spending by different customers over different months? Keeping the percentage/variance change as a visual!
Fantastic explanation - thankyou.
Thank you!
Excellent tutorial! Very helpful!
Thank you!, I'm glad it was helpful!
thanks a lot for the wonderful explanation
Glad it was helpful!
🙋 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!
it worked well. thank you!
Thank You! @Beulah
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.
Thank you ! works like a charm
Hi @Karma, Great to hear this. I'm glad it helped.
Awesome
Thank you Shoaib!
Keep Learning!
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.
Thank you so much!!!
Glad it helped!
@@AchieversDataEngineering Do you have a video on how to calculate YTD Monthly Average?
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
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!
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.
How to show the same period last year's month name as well in bar chart when we hover it?
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.
Nice
Thank you Mohit!
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.
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
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.
👍
Thank you!🙂
thanks
Thank you for watching.
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!
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
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.
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!
Dint understand u used Dax functions
Hi Ss, Which DAX function you could not understand?
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!
you are too fast and you dont explain each step especially for newbies
Thank you for watching.
You slow down the video by going into settings.
If you have a question related to any topic please feel free to reach out me.