Forum Discussion
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 d...
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
and format
"""" & if((SELECTEDMEASURE())=0, "none", SELECTEDMEASURE()) & """"
Power BI Dynamic Format Strings for Measures| Format without converting to text: https://youtu.be/qHALucET7N8