Matrix to Gantt Chart Visualization

[zan_mhd]

Hello,

I've been searching on the internet for solutions for a few weeks now and I still can't find what I'm looking for.

I required to visualize room utilisation per date based on AM/PM.

I created a time gantt chart using the matrix visualisation by date to show the bed utilisation from the time of admission of patients to time of dischare of admission for each bed. I managed to achieve this easily enough with the below code and conditional formatting.

and turned out to be like this

The problem is cant make more hierarchy to show AM/PM for each date. I'm stucked with that.

I want to visualize it to look something like below:

Hope anyone can help with this.

Thanks.

[v-yiruan-msft · Accepted solution]

Hi @zan_mhd ,

Please review the following links and check if they can help you achieve your requirement.

24 hour based gantt

Timeline by Queryon

Create A Gantt Chart In Power BI With A Matrix Visual

Best Regards