The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
@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))
Hi,
Thanks for the reply. Both options also show 0 values from the other 2 funnels which are not selected in the slicer element.