How to show 0 (zero) instead of (Blank) in a Tile from a report built within the Power BI Service?

[Anonymous]

Hi,
I have built a report within the Power BI Service itself. The report uses a OneDrive data source.
Due to building the report in the Service I am unable to create a measure to handle any (Blank) values that may appear (for example, IF( ISBLANK(value), 0, value) ).

The Tile showing the (Blank) is actually an Advance Card visual which does a distinct count on a column to show the number of entries, or (Blank) if there are no entries.

How can I show a 0 in the Tile instead of (Blank) for a report create within the Power BI Service?

Thanks.

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

According to my knowledge, I'm afraid it couldn't achieve in Power BI for now.

you need to create a measure in power bi desktop and then republish it to power bi service.

Power bi desktop is a development tool, power bi service is mainly for "Share"

All the modeling process should be done in the power bi desktop.

Best Regards,

Lin

[Anonymous]

Okay, thanks for the clarification.

I'm producing automated alerts on a Dashboard, where the alerts are not to have any type of manual or scheduled refreshes. Any refreshes must 'just happen' (automated) and to achieve this I have created the report in the Service, using OneDrive as the source.

Building the report via the Desktop will not allow the auto refreshing as I need.