Missing values in calendar layout format

[EdAbada]

Hello,

I am trying to create a calendar format matrix with rows based on Month and Week of the year and columns using week days (Mon, Tues..). Sales figures should show on the specific week and week day.

I am partly successful as you can see in the picture. However, there are missing weeks that do not show the sales values.

Here is a shot of my DimDate table where i use the calculated column ISOWk = WEEKNUM(DimDate[Date],2) and i also use Week in Year (ISO) which is hardcoded but the same values as ISOWk. Both give the same output which have missing values.

I enabled "Show items with no data" for ISOWk (rows) and Day in Week (columns). I did this so it will show a full calendar layout and not only showing rows or columns with values.

I would appreciate any help for all the numbers to show up.

Thanks.
Ed

[ChandeepChhabra · Accepted solution]

@EdAbada 
This is quite strange!

Here is quick workaround. Create a dummy sales measure and drag into the matrix visual

DummyTotalSales = sum(database[SALES])&""

Hopefully this should work

[Anonymous]

@EdAbada - This is a bug - I created an Issue - vote it up!

[EdAbada]

@ChandeepChhabra , it is indeed strange but it works! 

The sales value gets converted to a text format but i am ok with that.

Maybe there is another workaround for numeric values but this works for me.

Thank you so much!

Ed

[Anonymous]

@EdAbada - It seems like it should work - can you share a pbix?

Cheers,

Nathan

[EdAbada]

@Anonymous  Here is the link to the file. I would appreciate if you can help out. Thanks. 

https://www.dropbox.com/s/lq8g0du75v5h8zv/test.pbix?dl=0