Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
So like the attached PBIX?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |