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
CalvinBB01
Frequent Visitor

Blank value after filter condition

here i have below issue:

 

when there's no data with the filter, the value will be Blank.

If I change it to " if(isblank(Value), 0, Value)", then it will present 0 which is fine.
but when I create a daily chart with the value, there's lots of 0 showing from the chart which is not my purpose.

is there any good solution? many thanks!

CalvinBB01_0-1695280532592.png

 

1 ACCEPTED SOLUTION
ChiragGarg2512
Solution Sage
Solution Sage

Use Card(new) visual  ChiragGarg2512_0-1695296447480.png  in that in callout value section there is an option on what to display when the vaue is blank.

 

ChiragGarg2512_1-1695296619167.png

 

 

View solution in original post

5 REPLIES 5
ChandrashekaraD
Frequent Visitor

Open Power Bi Desktop  and go to Visualiztion Tab, you can see the Card Visual Screen shot is Attached ,

If you are not able to Locate ?

then click on the  three Dots you can see on the Visualiztion Tab Last and click on get more Visuals you can type card in the Search box and you can add to you power Bi desktop 

ania_roh
Helper III
Helper III

Hello,

If you change the measure like that, the chart will always show zeros. 

You have two solutions:
- put filter in the panel filter with the measure is not 0 :

ania_roh_0-1695301875349.png

- or create two different measures: one for the chart (leaving it as blank) and another for a card

 

Also, I recommend you use :
[Value] + 0
istead of:
 if(isblank([Value]), 0, [Value]

It is the same thing but it is more efficient. 

ChiragGarg2512
Solution Sage
Solution Sage

Use Card(new) visual  ChiragGarg2512_0-1695296447480.png  in that in callout value section there is an option on what to display when the vaue is blank.

 

ChiragGarg2512_1-1695296619167.png

 

 

Thanks, Where can i find the new Visual Card?

ChiragGarg2512_0-1695369326511.png

@CalvinBB01 If you still haven't found it.

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.