IF BLANK statement creates irrelevant data

[Anonymous]

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?

[MFelix · Accepted solution]

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.

https://www.google.com/search?q=youtube+powerbi+turn+off+auto+date%2Ftime&rlz=1C1GCEU_enPT819PT819&oq=youtube+powerbi+turn+off+auto+date%2Ftime&aqs=chrome..69i57j69i64.15879j0j7&sourceid=chrome&ie=UTF-8#kpvalbx=1

Regards,

MFelix