EBITDA shown as zero negative (0,0)

[Anonymous]

Hi amazing community!

The EBITDA in my report shows 0.0 but it should really be -0.0 as we are below the budget.

Does anyone know how can I show it as negative (0,0)? I have tried the FORMAT measure but it is not working.

Thanks!

[amitchandak]

@Anonymous , try like

Column = IF('Table2'[Column1]<=0,"(" & FORMAT('Table2'[Column1],"General Number") & ")" ,FORMAT('Table2'[Column1],"General Number"))

[Anonymous]

Hi @amitchandak 

Thanks for your reply but unfortunately, it is not working and it is changing all the negative values that I have in EBIDTA column.

[amitchandak]

@Anonymous , Sorry, But if you only need 0 try like

Column = IF('Table2'[Column1]=0,"(" & FORMAT('Table2'[Column1],"General Number") & ")" ,FORMAT('Table2'[Column1],"General Number"))

[Anonymous]

Hi @amitchandak 

The IF formula is not working. I have used FORMAT with this (see below) and I got the (0.0) but as I have 4 rows with 0.0, now I have all (0.0) and I just need 1 row as (0.0) row (Target YTD). Tricky one! 😞

[v-shex-msft]

Hi @Anonymous,

You can try to config these in field formatting. (0,0 seems not a valid format to number formats)

Use custom format strings in Power BI Desktop - Power BI | Microsoft Docs
Regards,

Xiaoxin Sheng