Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

How can I combine several similar values in one section?

Hi everyone,

 

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

Chart1.PNG

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!

1 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

 

6.jpg7.jpg

 

Or you can try to use the group feature:

8.jpg

 


By the way, PBIX file as attached.


Best regards,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-lid-msft
Community Support
Community Support

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,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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.   

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,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

 

6.jpg7.jpg

 

Or you can try to use the group feature:

8.jpg

 


By the way, PBIX file as attached.


Best regards,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.