Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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?Th ink.png

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

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 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

1 REPLY 1
MFelix
Super User
Super User

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 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.