PowerBi

[Himaja95]

I need to display NODATA instead of Blank,for the columns which do not have data.

For Example :

If I chose Activity = Walk in a filter,then it should be HoursSpent = NODATA (As there is No data ,it should show NODATA instead of Blank)

I have used this below code, but didnt work for me.

Isblank = 
VAR __Value = SELECTEDVALUE( 'Table 1'[Activity] )
VAR __Res = IF( ISBLANK( __Value ), 0, __Value)
RETURN
__Res

 Please help

[Himaja95]

@amitchandak ,I am new to PowerBi ,I didnt understand 
Could you please be more specific

[amitchandak]

@Himaja95 , Try to use Dynamic Format Strings, write this in format in Double quotes

example , I created measure

Measure = if(Max('Item'[Brand])  ="Brand 1", [Net], 0)
and format

"""" & if((SELECTEDMEASURE())=0, "none", SELECTEDMEASURE()) & """"

Power BI Dynamic Format Strings for Measures| Format without converting to text: https://youtu.be/qHALucET7N8