Empty Value in Filter Pane

[ShellyG]

Dear all, 

I would be very happy if you are able to help me with an issue I am experiencing with filter panes. 

I have created two of them on the same page - one is to select an year (2019, 2020, 2021) and the other one is to select a quarter sequence (Q1, Q2, Q3, Q4).

Both of the filters currently contain the above mentioned years and quarter sequences correspondingly, but they also contain one more field as an option, which is blank. When selected it does not show any specific data...

Could you please advice on how to remove these blank fields from the filters? I already tried un-checking the "Include Null Values" option, but it doesn't seem to make any difference.

Thank you in advance.

Best Regards,

Shelly

[Mauritz_SA · Accepted solution]

Hi @ShellyG 

I have a suspicion that you have actual blank values in that field. If you don't want to show them then you can use =AGGR(ONLY({<[Your Field]= {'=Len(Trim([Your Field]))>0'}>}[Your Field]),[Your Field])

Hope this helps.

Regards,

Mauritz

[lironbaram]

HI 

usually it means that you load an empty row to the table 

fix it there and not by applying expression to the fields 

[ShellyG]

Hi Mauritz,

Thank you for your suggestion, it worked perfectly! 

Have a wonderful day and take care!

Best Regards,

Shelly