Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@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
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.
I suppose you have figured it out by now. Else this link can help :