Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
BBConsultancy
Helper I
Helper I

Showing 0 values in the funnel visual without ignoring the filters

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?

2 REPLIES 2
amitchandak
Super User
Super User

@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))

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi, 

 

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors