Count of Blank Items missing.

[dparkinson]

Hi,

I have a column chart which shows a count of statuses from a spreadsheet.  Some of the fields are blank.

In the filters section, it clearly shows there are 11 blank entries, but the chart is not showing them.

The Axis has "Show items with no data" selected.

Any thoughts on how I can change this?

Thanks,

D.

[Sean]

@dparkinson create a simple Measure Count Scope RAG = COUNTROWS(TableName) and use it instead

seems the built-in count you are using - when you drag a column and change to Count of Scope RAG ignores the blanks

[dparkinson]

Sorry, I should have been clearer -- this is under the PowerBI Service forum, so I don't believe I have the ability to add a measure right?

I think we've resigned ourselves to using the desktop version now that it supports Sharepoint folder connectivity, so will give it a go.

Thanks for the response.

D.

[addd123]

I suppose you have figured it out by now. Else this link can help :

https://social.technet.microsoft.com/Forums/en-US/a90ee970-812d-447b-aece-6b99a73a6b7b/count-blanks?...