Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Weekly-based filtering of empty data.

Hi everyone,

I have this visualization that is connected with a calendar slicer (week numbers). 

The "9CM" column only has data from week 45 to week 52, meaning that for almost a year, it will be presenting empty values.

I therefore want to add some sort of dynamic filtering to this visualization, so that it automatically detects and filters when there is empty data for each week.

 

After several attempts with advanced filtering e.g., "IS NOT BLANK" & "IS NOT EMPTY" as well other methods - I have not had any success, unfortunately. I am therefore reaching out to all of you Power BI jedi's, hoping that the force is with me today.

 

Kind regards,

 

 Anonymous 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , Usually blank data is not shown in the report make sure it is now 0. That can be because you added +0 in measure if or used isblank in condition to handle blank.

     

    Or you have used this option