Forum Discussion

UncleLewis's avatar
UncleLewis
Responsive Resident
5 years ago
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...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    The OrderDate column on your Sales table is formatted as text.  Change that to type Date and it will work.

     

    Pat

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi,

I am not sure how your data model looks like, but in my opinion, it seems like there is an invalid relationship between fact table and date table.

If it is OK with you, please share your sample pbix file, then I can try to look into it to come up with a relevant solution.

Thanks.