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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Diana_Ning
Microsoft Employee
Microsoft Employee

Group several rows into 1 according to a certain column, with filter still working

My data is like below:

Course No. | Language | State

AZ-999  | EN-US | To Do

AZ-999  | ZH-CN | Doing

AZ-999  | JA-JP | To Do

AZ-888  | EN-US | To Do

AZ-888  | ZH- CN| To Do

AZ-888  | ES- ES | Done

I need these to display like:

AZ-999 | EN-US, ZH-CN, JA-JP| To Do, Doing, To Do

AZ-888 | EN-US, ZH-CN, ES-ES| To Do, Done

 

While this still responding to the filter "Language" and "State".

 

2 REPLIES 2
Diana_Ning
Microsoft Employee
Microsoft Employee

I mean like below, when Languaage ES-ES is selected in the slicer, I want the "Languages" column in the table shows only the ES-ES, the languages column is generated using table.join

 

Diana_Ning_0-1685933590311.png

 

Ahmedx
Super User
Super User

pls try this

_Language = CONCATENATEX('Table',[Language],", ")
_State = CONCATENATEX('Table',[State],", ")

Screen Capture #1186.png

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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