Create Measures tutorial not working

[Marke525]

I am trying to follow the tutorial and have come across this problem:  In the tutorial a matrix table is created like this:

It is revenue over month and year.  When I create the table and add revenue, it does this:

How do I get it to show the data by month and year, instead of lumping it all into a single sum.  I have no filters on, I've only placed MonthName in the rows box, Year in the columns box and Revenue in the values box.

Any suggestions?

[mahoneypat · Accepted solution]

Thanks for providing the pbix file.  The issue is that the Date column in your date table only has the month and day (no year).  If you make the relationship to the Date2 column instead, and make sure both the Date2 in the Date table and Date column in your Sales table both have data type Date, your visual will work correctly.  One of those two columns was text format, so needed to be changed.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Marke525]

That was perfect, well explained advice.  Thank you for your help, I really appreciate it.

[jdbuchanan71]

That looks like a bad join between Sales and Dates.  Can you share your .pbix file?  Upload it to OneDrive or DropBox and share the link here.

[Marke525]

Thanks for the response.  Here is the link to the pbix file:  https://1drv.ms/u/s!AmbVtuwcY2bdggOtRnM-cxJerROb?e=MXpXOm