Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Change measure format with IF statement

Hello,

I have a measure with IF statement. but I can not change format,. it seems text when I check on the top. and there is no other option to change. I checked all 2 input format from the database. but all are whole number on Power BI.   

Thank you in advance 

Baris 

 

 

 

 

 

 

Need Help

2 Replies

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

    Hi Anonymous ,

    Your if statement output is text (i.e., "Non", "Spike"), therefore, there is no option other than text.  

    Best regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hello

    Thank you but,

    actually I'd like to see total spikes and non spikes under the table but I can not. also I have changed the format as whole number but I can still not see.

    Regards