Reply
choicm
Regular Visitor

Display the only value from multiple columns in one column

Hi. I have a dataset like this:

choicm_0-1727321975156.png

How can I display the subcategory in one column? i.e. A1, B2, C2, A2, B3, C1 shown in one column.

Thank you.

1 ACCEPTED SOLUTION
choicm
Regular Visitor

Problem solved. I used a formula "=A1&B1&C1".

View solution in original post

1 REPLY 1
choicm
Regular Visitor

Problem solved. I used a formula "=A1&B1&C1".

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)