Forum Discussion
jerryr125
Helper IV
Helper IVMatrix 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 Fi...
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
vojtechsima
Super User
Super UserHi, 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.