Forum Discussion
Time date Matrix
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
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
6 Replies
So like the attached PBIX?
It is in a matrix table, it looks exactly like your image unless I am missing something obvious.
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
