Showing 0 values in the funnel visual without ignoring the filters

[BBConsultancy]

Hi,

I ran into a problem with the funnel visual. I use one funnel visual for 3 different funnels and one slicer element lets you select which of the three funnels is visible. By default, the funnel visual does not show 0 values which makes it incomplete.

In the settings, there is a function to show the 0 values, but when I choose that option it also shows 0 values from the other 2 funnels which are not selected in the slicer element.

Does anyone know how to show 0 values without ignoring the set filtering?

[amitchandak]

@BBConsultancy , we have try a measure like

0 between range
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))

or

Measure = var _1= SUM(Opportunity[Opportunity count]) +0
var _tab = values(Category[Category])
return
CALCULATE(if(max(Category[Category]) in _tab || max('Calendar'[Date]) >_max , BLANK(), _1))

[BBConsultancy]

Hi, 

Thanks for the reply. Both options also show 0 values from the other 2 funnels which are not selected in the slicer element.