Forum Discussion
IF BLANK statement creates irrelevant data
Hi everyone,
I have a small data set of only three months. Some variables had no data on a daily basis. To make a continuous line chart and matrix table, I've created a measure using the IF and BLANK statement (see image). However, in return, Power BI showed a table for the whole year. And adding a slicer didn't work, because the slicer showed only the three months I've actually data of. Can anyone explain what is going on?
Hi Anonymous ,
In Power BI there is an option on the Data load that if turn on autommatically transform any date column into a calendar table (beginning on january ending on December). You need to turn this off.
Check link below on why you should turn this off.
Regards,
MFelix
1 Reply
Hi Anonymous ,
In Power BI there is an option on the Data load that if turn on autommatically transform any date column into a calendar table (beginning on january ending on December). You need to turn this off.
Check link below on why you should turn this off.
Regards,
MFelix