Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Unable to apply filter in Funnel Chart
08-10-2021
04:44 AM
Hi,
I am unable to apply a filter on a funnel chart.
I need to filter where the Actual Cost is not less than 0, However, I am unable to do so for the below funnel chart.
Please help.
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-10-2021
05:25 AM

@jesly_ajin You can't plug 0 into that box right underneath is less than? You could do it in a measure:
Filtered Actual Total Cost = IF([ActualTotalCost]>0,[ActualTotalCost],BLANK())
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-10-2021
05:25 AM

@jesly_ajin You can't plug 0 into that box right underneath is less than? You could do it in a measure:
Filtered Actual Total Cost = IF([ActualTotalCost]>0,[ActualTotalCost],BLANK())
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-10-2021
05:50 AM

@Greg_Deckler Yes correct, I am unable to plug 0 into that box.
Where should I put this new measure so that the visual gets filtered?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-10-2021
07:17 AM

@jesly_ajin you would use that measure in place of whatever is currently in your Values field well for you Funnel chart
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
06-02-2024 06:12 AM | |||
04-23-2024 03:06 AM | |||
07-15-2024 07:20 AM | |||
10-04-2024 06:35 AM | |||
09-18-2024 08:18 PM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
141 | |
115 | |
83 | |
63 | |
48 |