I am befuddled. I have two tables I want to use to create a visual, one is the calendar (date) table, with several columns including month, month name, quarter, day name, day of week, etc. The other table has accounts, cars parked by account, check in date for when the cars parked, etc. I have calendar date linked to CheckInDate in my data table.
I can easily get a visual of all cars parked by account, with account showing on the axis. However and for instance, if I want to show cars parked by day of week, it doesn't work. If I put 'calendar'[date] in for the axis it arbitrarily (it seems) shows March 25 and gives cars parked as 1. If I try [day name] it gives me two axis items, Sunday (March 25 was a Sunday, probably not coincidentally), cars parked 1; Blank, cars parked 266.3k. If I use [day of week] it shows 7 on the axis (Sunday is my 7th day of the week) and 1 car parked.
What I want, of course, is when I use day name I get all seven names of the days of the week and cars parked for each day, all totalling up to about 266.3k. Same for day number, I would like 1-7 on the axis, etc.
If someone can help me understand what is going on I would love to hear it!
- Craig
