Forum Discussion
Matrix won't display/include all months
I'm using Matrix to compare data between two years from Jan to July. Under Filters, I ensure July is selected/included but the Matrix stops at June. I'm using Date Hierachy and the data has date field dd/mm/yy. Does anyone know how I could include July?
Thank you.
Thank you for the tip...I just changed the DOCDATE field within the data pane from dd/mm/yy to mm/yyyy and it works!!!
3 Replies
- Ashish_Mathur
Super User
Hi,
Could be that someother filter criteria/slicer is coming in the way. Also, ideally you should have a Calendar Table with a relationship from the DOCDATE column to the Date column of the Calendar Table. Create a Month column in the Calendar Table and drag the month column to the visual.
Thank you for the tip...I just changed the DOCDATE field within the data pane from dd/mm/yy to mm/yyyy and it works!!!
- SteveCampbell
Memorable Member
Do you have data for July?
First, try clicking on the arrow next to DOCDATE in columns field, and select "Show items with no data".
