count by categories and date

[clteh9]

hi, 

i would like to check how can i format the visual as below. 

this is my sample data.

Thanks in advance. 

[mangaus1111]

@clteh9 ,

sorry the calculated column must be like this

End Date = CONVERT(INT('Table'[End Time]),DATETIME)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu · Accepted solution]

@clteh9 

you can try to use a matrix

pls see the attachment below

[clteh9]

i tried it in the power bi. it show the report as such instead of showing category and subcategory in diff columns. Can help? thanks

[ryan_mayu]

@clteh9 

pls turn off stepped layout

[clteh9]

thanks

[ryan_mayu]

you are welcome

[mangaus1111]

Hi @clteh9 ,

create a calculated column 

End Date = INT([end time])

 and then a measure 

Count = COUNTROWS('Table')

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.