Forum Discussion
Solved
Heatmap Formatting - Display Days and Hours (Custom Axis Labels)
Hi everyone, I'm working on a Heatmap in Power BI to visualize total calls offered by day. However, I'm facing an issue with the axis labels. Currently, the rows display sequential numbers (1...
Hi manoj_0911
It is the same step as before.
Create a claulated column
HourNo = HOUR([IXN_SUBHOUR_DATE])Then sort it ascendng, then select the hour column, select sort by HourNo
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
What you need is to use a calculated column or a column from dimension table with the desired format of days and hours in the visual.
Regards