How to get 0 instead of Blank

[Sudharshan1919]

Hi All,

I am using a custom column to show the values is cards. I am placing the column in card and for the card filter i am slecting the respective value to be shown as count. When there are some values it is showing as count, but when there are no values it is showing as Blank. Here, in the Blank place i need the value to be displayed as 0.

I am attaching a small image which can be understood quickly.

Here, I am having a set of servers in which maintenance mode is On/Off.. In the Off Card and the On Card i have kept the Calculated column and selected the Respective filter for both the cards... When there are No Values of that filter, it is showing as Blank. 

NOTE : I need to achieve this without using any Measures. 

Appreciate a quick help on this.

Thanks,

[v-chenwuz-msft · Accepted solution]

Hi @Sudharshan1919 ,

For Power Bi, it looks like you put a column on the card; in fact, Power Bi automatically creates a measure for that column and places that measure on the card.

Therefore, this column in the card is a summary measure.

You can try this measure to replace it.

Measure =
IF ( ISBLANK ( COUNTROWS ( 'table' ) ), 0, COUNTROWS ( 'table' ) )

If you need more help, please share your pbix file without sensitive data.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[selimovd]

Hey @Sudharshan1919 ,

why do you need to achieve this without measures?

If you just use a column you cannot replace a blank with a zero.

Best regards

Denis

[Sudharshan1919]

Hey Denis @selimovd ,

Actually i need to show even the Historical data also. The source that i am having is excel.

First we have displayed only the latest data by using the measures. But the Requirement now was given to show Historical data, and when we tried with measures it was not working.. it is either showing the sum of whole data or the latest data.

Thats the reason i need it without measures.

Thanks

[selimovd]

Hey @Sudharshan1919 ,

if you give further details I could take a look into it or propose a solution.

With the requirements you gave it's not possible.

Best regards

Denis