Forum Discussion
Replacing a blank with a 0
Good Afternoon All I have a table on my Power BI as a visual. Is there a way i can make all the blank cells a ? Please see the attached picutre.
amitchandak
Super User
Super UserAnonymous , Based on what I get, a new measure
if(isblank([measure]), "A",[measure])
But this might force left join
amitchandak thankyou, i assume i just add the new measure under 'Values'
I am recieving the below error
- amitchandak
Anonymous , close ) asfter isblank(Query[Instance])
if(isblank(Query[Instance]), "rto",isblank(Query[Instance])&"")