cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
simonchung Frequent Visitor
Frequent Visitor

Show items with no data in selected date period

Hi Experts, 

 

I wonder if it is possble to write a measure, to display date information that the day have no data, as shown

 

image.png

 

This is the desired output

 

image.png

 

Many thanks!

 

Simon

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Show items with no data in selected date period

Hi @simonchung 

 

You may create 3 measures to get the date value.Then drag them to visual level filter.Attached sample for your reference.

Date of A without Data = IF(ISBLANK(SUM(Table1[A])),1)

1.png

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Show items with no data in selected date period

Hi @simonchung 

 

You may create 3 measures to get the date value.Then drag them to visual level filter.Attached sample for your reference.

Date of A without Data = IF(ISBLANK(SUM(Table1[A])),1)

1.png

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
simonchung Frequent Visitor
Frequent Visitor

Re: Show items with no data in selected date period

Hi Cherie

 

Many thanks for your help!

 

Simon