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

Re: How to deal with a "(BLANK)" value in a card visualization

+0 works very well for me!!

 

Matt

Highlighted
Helper I
Helper I

Re: How to deal with a "(BLANK)" value in a card visualization

Im quite new to power bi. can you please help me here ?

 

I have a card which counts total values in column A. if if select specific values in slicer sometimes it comes up as (blank) instead of zero.

 

if i need to create Measure = expression + 0 - what should be under expression ? measure = sum(table[column A]) + 0 ? and how to apply it to the card when the measure is created ?

 

thank you

Highlighted
Frequent Visitor

Re: How to deal with a "(BLANK)" value in a card visualization

 Hi Misakkk,

 

Check this out...

 

Measure= IF(CALCULATE(count(column),column ="condition") >0,CALCULATE(count(column),column ="condition"),0)

Highlighted
Frequent Visitor

Re: How to deal with a "(BLANK)" value in a card visualization

Super clever!! tnx

Highlighted
Helper I
Helper I

Re: How to deal with a "(BLANK)" value in a card visualization

Has someone created a suggestion to add functionality to the fields to add a 0 if blank? Creating a measure for every card is too excessive and limits functionality......

Highlighted
Frequent Visitor

Re: How to deal with a "(BLANK)" value in a card visualization

Highlighted
Helper I
Helper I

Re: How to deal with a "(BLANK)" value in a card visualization

Here is a more popular one. There are many more ideas posted that are similar.

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10110324-count-should-return-0-in...

Highlighted
Advocate I
Advocate I

Re: How to deal with a "(BLANK)" value in a card visualization

Add a New Measure. 

Assign your expression and " + 0 " at the end.

Ex:

NewMeasure = Sum(Table_Name[Field_Name]) + 0

Highlighted
Advocate I
Advocate I

Re: How to deal with a "(BLANK)" value in a card visualization

Hi @misakkk ,

 

Right click on the left side pane on any Field name and Click "Add New Measure".

Give a name to the measure. Ex: MsColumnA

Assign your expression and " + 0 " at the end.

Ex:

MsColumnA = Sum(Table_Name[columnA]) + 0

 

Now your new measure will appear on the left side pane. 

Drag and drop it to the Card Field.

 

Highlighted
Post Patron
Post Patron

Re: How to deal with a "(BLANK)" value in a card visualization

This one is really superb!

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors