topic Re: Group values on pie chart in DAX Commands and Tips

Group values on pie chart

MasterSonic — Sun, 20 Nov 2022 13:29:02 GMT

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 ?

Re: Group values on pie chart

FreemanZ — Sun, 20 Nov 2022 13:33:28 GMT

you would need a new measure.

Other := [In Process] + [Unknown]

Re: Group values on pie chart

MasterSonic — Sun, 20 Nov 2022 13:59:54 GMT

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

Re: Group values on pie chart

FreemanZ — Sun, 20 Nov 2022 15:23:11 GMT

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.

Re: Group values on pie chart

MasterSonic — Sun, 20 Nov 2022 15:25:47 GMT

Yes column name is Status

with values I mentioned.

Re: Group values on pie chart

FreemanZ — Sun, 20 Nov 2022 15:44:45 GMT

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.

Re: Group values on pie chart

MasterSonic — Sun, 20 Nov 2022 15:56:03 GMT

Thanks that works good.