cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Black_magic100 Helper III
Helper III

How to filter out values that are blank in a visual

Untitled.png

Growth Decline EFT Paid MoM = IFERROR([EFT Paid MTD]-[EFT Paid LM]-1,BLANK()) <---- this is my measure for the graph above.
 
I don't simply want to filter out values less than a number, but rather the values that are blank.
6 REPLIES 6
Super User IV
Super User IV

Re: How to filter out values that are blank in a visual

Is that a waterfall chart? Would be easier to replicate with data or the file. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Black_magic100 Helper III
Helper III

Re: How to filter out values that are blank in a visual

Formulas: 

Growth Decline EFT Paid MoM = IFERROR([EFT Paid MTD]-[EFT Paid LM]-1,BLANK())
 
EFT Paid MTD =
TOTALMTD(SUM('Payments'[Amount]), 'Payments'[PaymentDate])
 
EFT Paid LM = CALCULATE(SUM('Payments'[Amount]), PREVIOUSMONTH('Calendar'[Date]))
 
For the visual I am using a standard calendar date table for the x axis and the y axis is simply taking 'Payments'[Amount] and summing it, aggregated by month obviously.  The measure at the top takes the current month total and subtracts it by the preceding month as a whole to get the difference.  
 
Right now I have a visual filter to only show 2018 and 2019 as our data only goes back that far, but on some of our locations (selected using a slicer) it might only go back a month or two.  The issue is that it is showing 2018 entirely even if there were no payments for that location during that time period.  
 
The payments table is very simple.  It has a date, storeID, and the amount for each.
Ronald123 Resolver II
Resolver II

Re: How to filter out values that are blank in a visual

Hello @Black_magic100,

 

You can use a second visual filter with your measure "Growth Dceline.."
Select nog equal to blank and/or zero.

 

Greets,

 

Ronald

Black_magic100 Helper III
Helper III

Re: How to filter out values that are blank in a visual

So I tried that, but it did not work.  The values just remained.  Even when I tried not including values that are equal to 0 they still just remained.  I even added more decimal places to makes sure they were actaully zero.  Not sure why that wouldn't work?

Black_magic100 Helper III
Helper III

Re: How to filter out values that are blank in a visual

Okay I did a slightly ghetto approach using what you said...  I just said "if greater than 1 OR less than -1".  That should be fine as the chances a growth/decline is within that value is very very very unlikely, but I still would like to know what this is.

Microsoft
Microsoft

Re: How to filter out values that are blank in a visual

Hi @Black_magic100,

Could you have tried use the Advaced filtering with is not blank:

1.PNG

And could you have checked if you have selected the "show items with no data"?

1.PNG

 

Regards,

Daniel He

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors