I have grouped several codes, but when I tried and add in a conditional format the groups separate

[Adavin]

Hi,

I have grouped several codes, but when I tried to add in a new column to show Negative and Positive figure using the below the groups separate out

Brackets - Variance YTD 2 TEST 2024/25 =

FORMAT('Income'[Variance YTD],

"#,0.00;(#,0.00)")

Any ideas please

Alice 

[MasonMA]

With FORMAT(), your numeric measure is converted into text data type and once it’s text, Grouping treats values as distinct strings, not numbers anymore. 

So, Keep your original measure numeric

Measure =
SUM('Income'[Variance YTD])

In Model view select the measure and set format to:

[Adavin]

HI,

Perfect than you so much. 

Kindest 

Alice

[v-dineshya]

Hi @Adavin ,

Thank you for reaching out to the Microsoft Community Forum. could you please confirm whether your issue is resolved or not?  Let us know if you’re still facing the same issue we’ll be happy to assist you further.

Regards,

Dinesh

[v-dineshya · Accepted solution]

Hi @Adavin ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh