Forum Discussion
Matrix Visulization - Row issue
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
6 Replies
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, 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.
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!!
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!!
