BLANK ON DATE FILTER

[Ucboy4]

Hi Everyone,

my date filter can't seem to working properly. Majority of my data seem to be on blank.

[v-yangliu-msft · Accepted solution]

Hi  @Ucboy4 ,

Whether your [call_disposition] is another table of data.

I created some data:

Date:

Because the data in Table is 2022.7.1—2022.8.30, and the data in Date is 2022.1.1. – On 2022.12.31, missing data in the Table will be displayed as blank values.

If you don't want to display these blank values, you can select Blank without selecting them in Filter.

If you need pbix, please click here.

BLANK ON DATE FILTER.pbix

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly