How can I combine several similar values in one section?

[Anonymous]

Hi everyone,

Does anyone know how I can combine several values under 'Other (specify)' names (the screen is attached) in one section? 

More answers with different specifications under 'Other' will come soon, and I don't want to overwhelm my chart with these answers, but rather to combine them in one.

Thanks a lot!

[v-lid-msft]

Hi @Anonymous ,

We can try to create a calculated column as the  new axis field.

Type =
IF (
    CONTAINSSTRING ( [Type of Initiatives], "Other (Specify)" ),
    "Other (Specify)",
    [Type of Initiatives]
)

It will output Other (Specify) if type contain it, and return origin type if not.

If it doesn't meet your requirement, kindly share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to OneDrive For Business and share the link here.

Best regards,

[Anonymous]

Hi @v-lid-msft! Thanks for your answer, but unfortunately, it's not working. Maybe because every single entry containing "Other ..." is different from another, so when I'm trying to apply this formula, it doesn't recognize "Other (specify)". Also, it doesn't allow me to choose the data column when I'm entering CONTAINSSTRING.

I decided to replace the primary data with just "other" and added another column for specifications.   

[v-lid-msft]

Hi @Anonymous ,

How about the result after you follow the suggestions mentioned in my previous post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

it doesn't allow me to choose the data column, we think you are tring to create measure instead of calculated column, please refer to our sample file

Or you can try to use the group feature:

By the way, PBIX file as attached.

Best regards,

[Greg_Deckler]

Not clear. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490