Power Bi Card showing as (Blank) on Filtered Count of Text

[jake97]

Hi All, 

I'm a Power Bi novice! I have established a Power Bi report, and within the report I am counting the text value for a 'Completed' column. The text results are only 'True' or 'False'. 

I have a count of all occurances which works fine, I am then counting all "True" values, all "False" values and all "False" values that are before today's date. As pictured below. 

When I publish the report to My Workspace, the report initially shows as desired. When a dataset refresh occurs, I keep receiving the below result. 

Does anyone know how to fix this issue? I've tried to create new columns, measures, etc. to no avail. I can't find an answer anywhere. 

Any help is appreciated!

[Anonymous]

Hi, 

You can hide the blank value using a Conditional Formatting rule on the Callout Value. The rule is 'if blank' then select the same color as the card or canvas background. 

I have created a video tutorial on how to create the conditional rule: https://youtu.be/Xsmbfpa4oCA

[jake97 · Accepted solution]

Fixed the issue! Converted the column to True/False data type, then used a measures to get count:

TrueCount = COUNTAX(FILTER('Table',[Completed]=TRUE()),TRUE())

And a measure so the card shows as '0' not '(Blank)' if no data:

TrueCountIf = IF('Table'[TrueCount]>=1,[TrueCount],0)

[PhilipTreacy]

Hi @jake97 

How are you counting the values that show as BLANK?

After the data refresh, what data is in your dataset?  Can you please provide this data.

Regards

Phil

[jake97]

Hi @PhilipTreacy, thank you for your response!

There are no blanks in the column I am counting. The data is populated from a SharePoint list, the default for "Completed" is FALSE (No). 

Below is what the data looks like for the column I'm counting. 

Is there anything else I can provide you with? 

Thank you very much.