Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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!
Solved! Go to Solution.
Use Card(new) visual in that in callout value section there is an option on what to display when the vaue is blank.
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
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 :
- 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.
Use Card(new) visual in that in callout value section there is an option on what to display when the vaue is blank.
Thanks, Where can i find the new Visual Card?
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 21 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 35 | |
| 31 | |
| 19 | |
| 13 | |
| 10 |