Matrix won't display/include all months

[quattr0]

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.

[Ashish_Mathur]

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.

[quattr0 · Accepted solution]

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]

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".