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 h...
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
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
It is in a matrix table, it looks exactly like your image unless I am missing something obvious.
Greg Sorry my fault. thanks for te excellent feedback as always