Visual filter disable after "Show items with no data"

[Anonymous]

Hello,

I have an issue.

Task is to show opportunity sum in last three months by day and showing days with no data.

Somehow when I check "Show items with no data" visual filter (last 3 month) became disabled.

I'm struggling all day, maybe I'm looking in wrong direction:

• I've created measure, that brings zero with opportunity count is blank
• Joined Date table

None of it worked. Expected outcome and result in the picture. Link to pbix example below.

Keep in mind there will be a big size of data, so solution must be clean.

Thanks in advanced!

https://drive.google.com/file/d/1qAO9bmTbRetcVocXXMH1bwPtA0QAIVGi/view?usp=sharing

[amitchandak · Accepted solution]

@Anonymous , Create a measure like

Measure = var _1= SUM(Opportunity[Opportunity count]) +0 
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date]) 
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date]) 
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))

[littlemojopuppy]

Hi @Anonymous 

Is this what you're expecting?

All I did to change it from what you posted to this was in the well for axis was change it from the date hierarchy to just the date like this