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:
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!
Go to Solution.
@rimgrs , 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])
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))
Proud to be a Super User!
View solution in original post
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
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.