Sales Analysis Heat Map by TIME & DAY on POWER BI | Analysing Hourly Sales Data Trends using M Query

In this tutorial, we will understand how to get sales trends on the basis of the Time of the day and day of the week.
We will be using the Power Query M formula to get the round figures and then use them in the visuals to get the desired results.
#powerbi #powerbitraining #powerbitutorial

[@shreya6115]

I never thought like this.
Wonderful video for all POWER BI developers.

[@analyticalguy]

I’m glad you liked the video 👍

[@Gua10ify]

Thank you

[@vinarshi793]

Thank you so much!

[@analyticalguy]

I’m glad it was helpful to you :)

[@ProudlyConfused]

Amazing video, thank you - I spent a good amount of time trying to do this. The sort for day of the week was a nice trick!

[@analyticalguy]

I am glad it was useful. Thank you 🙏

[@ProudlyConfused]

@@analyticalguy I did get some error rows with the time calculation though, anything past 11pm, so went this route as I did not need to round them up, the -5 is for timezones adjustment,
HourFormatted = FORMAT('Email Data'[Date Time]-time(5,0,0), "hh AM/PM")

[@sandipjabade1]

Great video on conditional formatting

[@analyticalguy]

Thanks Sandip for your kind wordsZ what else would you like to study?

[@analyticalguy]

CSV & PBIX file for this tutorial - bit.ly/3gbaT2H

[@beingbeautiful2680]

Thank you so much fot this

[@analyticalguy]

I’m glad this tutorial helped you 🙏

[@shrawankumar-yp4xs]

thanks for the nice video....Sir, i request you to please make a video on "SOLVER". That video will be a privilege for us

[@analyticalguy]

Sure, I’ll make a video on Solver separately. Did you get a chance to watch this tutorial on WHAT IF analysis - ua-cam.com/video/LfR1bG8auaY/v-deo.html

[@shrawankumar-yp4xs]

@@analyticalguy I'll watch it now

[@roses292]

Hi Sir, I am getting error 'DataFormat.Error: We couldn't convert to Time.
Details:
1' ========= for the time: '11:45 pm to 11:59 PM' and the cutsom_time value for the corresponding times are 1 and the error happens when i convert it to Time data type.Can you please get me a solution for this

[@sattaralam7818]

All is right sir but why don't you upload excel or csv file

[@analyticalguy]

Thanks Sattar for your suggestion. I have added the PBIX file for this.

[@sattaralam7818]

@@analyticalguy sir only Excel file no need power bi file, please upload Excel file

[@analyticalguy]

@@sattaralam7818 Hi Sattar, I have uploaded the CSV file for the same. pls check the link bit.ly/3gbaT2H

[@sattaralam7818]

@@analyticalguy thank you sir, God bless sir

[@sattaralam7818]

Please upload Excel or csv file

[@analyticalguy]

Shared in the comments :)