Group values on pie chart

[MasterSonic]

Hi guys,

I have basic pie chart showing status - 'Sold', 'Leased', 'In Process', 'Unknown' with corresponding %.

I would like to see that pie chart as

'Sold', 'Leased' and 'Other':

( where 'Other' = combined value of 'In Process' and 'Unknown')

Is it possible please ?

[FreemanZ]

you would need a new measure.

Other := [In Process] + [Unknown]

[MasterSonic]

Actually I just read about option New Group, once you right click on column. Seems like it will work for me.

But could you elaborate this dax formula please? It could also be useful 

[FreemanZ]

Are 'Sold', 'Leased', 'In Process', 'Unknown' the values in one of your column? It would be good if you could provide a sample data, with table name and column names. 

[MasterSonic]

Yes column name is  Status

with values I mentioned.

[FreemanZ · Accepted solution]

Try to add a new column with the code below:

Status2 =

IF (

    [Status]="In Process" || [Status] = "Unknown", 

    "Others",

    [Status]

)

 

it worked like this:

Then plot the pie chart with the new column.

[MasterSonic]

Thanks that works good.