Hi - I have the following matrix visualization:
I would like to show one row per date - example:
| Response Date | 1 | 2 | 3 |
| 3/9/2025 | 1 | 1 | |
| 3/10/2025 | 1 | 1 |
The Fields are the following:
Rows : AttendanceDate
Columns: ShiftNumber
Values: Count of ResponseID
Any thoughts ? thanks - Jerryr
All dates, times and datetimes in Power BI are the same datatype: datetimes.
If you import a datetimes and set its type in Power BI to date, the time is still there but hidden. Try going to PowerQuery and setting the data type of Response Date to date to strip the time out
Hi - thank you - this was the issue. I was using a field with 'date and time'. Problem solved. Thank you!
Hi, @jerryr125
it's weird that it doesn'T work by default, look:
Make sure you have calendar connected to your AttendanceDate (data type as DATE) and use the Calendar as ROW. Also just to make sure, you should write explicit measure (DAX) as Values.
