Value of hour compared to maximum value of year

[Innerv1sion]

Hello,

I am quite new to Power BI and still need to get used to the different way of writing formulas compared to Excel.

What I'm trying to achieve is creating a heat map based on quarter hourly data. I want to create a heat map with columns as hours and rows as dates. But I can't seem to find the correct formula for my calculation. I want to calculate the maximum value of x hour for x day and compare it to the maximum value of the complete year. 

The result should then be a heat map showing colors on how that hour's value is relative to the maximum value of the complete year.

Does anyone have any advice for this problem?

Thank you very much!

[v-piga-msft]

Hi @Innerv1sion,

Do you want to create the Table Heatmap visual or others?

If it is convenirnt, could you share some data sample and your desired output so that we can help further investigate on it?

For reference: Hour

Best Regards,

Cherry