Time date Matrix

[Anonymous]

Hi Experts

I am trying to produce and time v Date matrix with conditional ofrmatting to show the density for the number of time people have visted a website.

Across the columns i would like to have unique dates and down the rows the hrs in 24hr clock format. 00:00 t0 24:00 and the values for the site vists to be added into the relavent buckets (see image below). 

My data set has mulitple vists per day... 

Link: to sample data https://www.dropbox.com/s/g1co4nqqzp4yavo/time.pbix?dl=0

 

[v-lili6-msft · Accepted solution]

hi  @Anonymous 

For your case, you could try this way as below:

Step1:

Create two calculate columns that

Weekday = FORMAT([Date],"dddd")

Weekday num = WEEKDAY([Date],2)

Step2:

You'd better change the data type for [Time] column as below:

Step3:

Create a simple measure

Measure = COUNTROWS(Sheet1)

Step4:

then create a matrix as below:

Of course, you'd better set the sort by column for weekday column.

https://radacad.com/sort-by-column-in-power-bi

and here is sample pbix file, please try it.

Regards,

Lin

[FrankAT]

Hi,

you can find my solution here.

Regards FrankAT

[Greg_Deckler]

So like the attached PBIX?

[Anonymous]

Hi Greg

the final result has to be in the same format as the image i attached to the question...in a matrix table. dates across the top and time running the side vertically 

[Greg_Deckler]

It is in a matrix table, it looks exactly like your image unless I am missing something obvious.

[Anonymous]

Greg Sorry my fault. thanks for te excellent feedback as always