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
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

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 Kudoed Authors