Forum Discussion

manoj_0911's avatar
manoj_0911
Kudo Commander
2 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

manoj_0911's avatar
manoj_0911
Kudo Commander
2 years ago

Sorry, I missed adding this info before also I want the hours in this order 12am,1am,2am,3am,4am,5am,6am,7am,8am,9am,10am,11am,12pm,1pm,2pm,3pm,4pm,5pm,6pm,7pm,8pm,9pm,10pm,11pm

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

  • manoj_0911's avatar
    manoj_0911
    Kudo Commander
    2 years ago

    Fantastic thank you so much it worked

  • manoj_0911's avatar
    manoj_0911
    Kudo Commander
    2 years ago

    Hi I need one help, I have a field , 

    X-AXIS = MonthYear = FORMAT('AGENT_SUBHOUR_V'[IXN_SUBHOUR_DATE], "MMM-YYYY") and Y-AXIS = OFFERED.  the sorting of month-year is not proper, how to create a MonthYearNo for this?