How to create month over month Analysis Chart in Power BI

#Achieversdataengineering #powerbi #powerbitutorial #dax #learnpowerbi #powerbitutorial #powerbitraining

In this video we have discussed in details about how to create month over month Analysis Chart in Power BI.

[ltqqkeo]

Thanks. It was very easily understandable and smooth while implementing.

[kys]

Thank you for the amazing breakdown of this chart VERY INSIGHTFUL!

[brunovanherpe]

thanks a lot for the wonderful explanation

[Juggatweet]

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!

[Ayuk]

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?

[sunilvarma]

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.

[Mahesh]

🙋 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

[shabimosesa]

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

[mariapradeepm]

How to show the same period last year's month name as well in bar chart when we hover it?

[unitedwings]

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

[putrijuniarti]

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.

[pl]

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

[alghbashnehmohammad]

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

[koteswaribapatla]

Hi, here i want to divide previous month sales with previous month number.can advise me how to write with dax formula.thanks

[aayushshrestha]

HI Sir, can you please provide this excel sheet so that I can practice along with the tutorial. Thank you

[namitamehta]

I have May- Sept customer data in excel and need to make weekly dashboards based on metrics, How can I approach that

[shivasai]

How can we give the colouring for data label based on high and low

[xzpqkoo]

How to calculate sales per week without creating new column?

[ttcibqv]

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