Matrix Visulization - Row issue

[jerryr125]

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

[v-sathmakuri]

Hi @jerryr125 ,

Since the issue has been resolved, please consider marking the helpful response as "Accept as Solution" to make it easier for other members to find.

Thank you!!

[v-sathmakuri]

Hi @jerryr125 ,

Thank you for reaching out to Microsoft Fabric Community.

As the issue has been resolved, please consider marking the helpful reply as the Accept as Solution to assist other members in finding it more easily

Thank You!!

[Deku · Accepted solution]

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

[jerryr125]

Hi  - thank you - this was the issue. I was using a field with 'date and time'.  Problem solved.  Thank you!

[Deku]

No problem

[vojtechsima]

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.