Looking for the right chart in Power Bi

[sschoneveld]

Hi Eveybody,

I am exploring Power Bi for some weeks now but I am not able to find a solution to find a chart that fits my wishes. For now I made an overview in Excel but I woult like to transform it to Power Bi and create a nicer visual. 

In this example i have 2 desk (in real much more) and i would like to make visual at what times the most people are waiting divided by disk / per minute / per hour. 

What is the best possible way to create an visual like below?

Many thanks for your help.

[mlsx4]

You can use a Matrix. For instance here I have the category in the rows, the days in the columns and some measure like a rate, budgeted, difference...

Then you apply conditional formatting for the measures you need

[sschoneveld]

thnx good start. But just to make clear. If 2 peope are waiting: 

1st from 10:00 - 10:15

2nd from 10:05 - 10:30

the visual needs to show:

1 person waiting from 10:00 - 10:05

2 persons waiting from 10:05-10:15

1 person waiting from 10:15-10:30