Forum Discussion

Himaja95's avatar
Himaja95
Icon for Helper I rankHelper I
2 years ago

PowerBi

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

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    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