Hi There,
I have a Fact table containing sales per date (there are some dates missing), I have then added a calendar table that has dates from 1900-01-01 to 2050-12-31.
I have created a column chart with the calendar dates hierarchy (Year,Q,M,D) and added this to the axis, and use the following measure to display the values:
Total Value = CALCULATE(SUM(SALES[VALUE]))
When on the Year level all it good, however as soon as I drop to the next level i.e. Quarter, I get the (I) appear that contains the following warning "Chart data contains not a number (NaN) values".
I used the following Dax measure to check for errors in the VALUE column:
CheckForErrors = ISERROR(SUM(SALES[VALUE])) - This returned FALSE.
I have checked the Value column for zeros, Blanks/Null - there are none.
I have toggled the X-Axis from Type from Categorical to continuous. and I still get the (I) message appear.
I have added the data to a matrix vis and do not see any problems.
If I change the Date hierarchy to just dates, I dont get the errror.
I have tried to create a simplier version of the pbi file to share, but when I do, I dont get the error.
What is going on? what could I be overlooking?
I am happy for someone to T-V into my PC to check it out if that helps in anyway
