Forum Discussion
Solved
Days Of Week Disappear From Maxrix Visual
Hi all, Using Power BI Desktop July, 2021. I have a Calendar and Sales Tables The tables are 1:M on Date Field. I put the DayName on Rows in Matrix Visual I then added Total Sales to Value...
The OrderDate column on your Sales table is formatted as text. Change that to type Date and it will work.
Pat
Thanks Jihwan,
I uploaded to OneDrive : https://tinyurl.com/jm4deeea
If it does not take you directly to the pbix its in //public/power_bi/aw2.pbix
The 2 Matrices are on Page 9.
Thanks,
-w
-w
The OrderDate column on your Sales table is formatted as text. Change that to type Date and it will work.
Pat