cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rimgrs
Helper I
Helper I

Visual filter disable after "Show items with no data"

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!

Capture.JPG

 

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

 

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@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]) 
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))


Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
amitchandak
Super User IV
Super User IV

@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]) 
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))


Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

littlemojopuppy
Super User I
Super User I

Hi @rimgrs 

 

Is this what you're expecting?

littlemojopuppy_0-1610030953581.png

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

littlemojopuppy_1-1610031046602.png

 

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors