How to combine some status field from SharePoint to be used in a pie chart

[jsanz1]

Hello,

i have a question regarding combining some status updates into one. My dashboard is pulling up information from sharepoint and the status updates are being populated from a choice field. my question is, how to combine status 1 and 3 into a pie chart and keep all of the other ones as they are.   I have 15 status updates and 2 of them need to be combined, and leave the other 13 alone to show in a pie chart. Your help is appreciated.  

Title	Name	Status
xyz	user 1	1
xyz	User 2	2
xyz	user 3	3
xyz	User 4	4
xyz	user 5	5

[Anonymous · Accepted solution]

Hi @jsanz1 ,

I suggest you to create a calculated column by dax.

New Status = 
IF('Table'[Status] in {"1","3"},"New Status",'Table'[Status])

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.