Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    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

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

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