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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
maracles
Resolver II
Resolver II

Visualisation option that allows for text format data to be used as table/matric values.

Hi,

I'm trying to create a table visualisation that is all text values. The row and column headers are text, but then so are the value completing the table. For an illustration of my data see the image below:

My column headers are 'Departments'. Under each of those departments I want to list the 'Roles' within each department. My data is set-up so that each role only belongs in one department. 

 

The table below is close to what I want but it is using 'First' value whereas I want it to list every value. 

 

maracles_0-1647976059757.png

 

Thanks for suggestiosn .

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@maracles , Not very clear. But you can create measure using concatenatex and use that

Concatenatex: https://www.youtube.com/watch?v=du2HSEzng2E&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=43

 

 

concatenatex(Table, Table[Column], ",")

View solution in original post

3 REPLIES 3
maracles
Resolver II
Resolver II

@amitchandak I have actually tried your solution and it is working. Is there though a way of getting each value on it's own row, rather than having them all in one row but with linebreaks? 

For anyone else looking for this solution you can add Line Breaks with & UNICHAR(10) 

amitchandak
Super User
Super User

@maracles , Not very clear. But you can create measure using concatenatex and use that

Concatenatex: https://www.youtube.com/watch?v=du2HSEzng2E&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=43

 

 

concatenatex(Table, Table[Column], ",")

Thanks @amitchandak - sorry it wasn't clear. If this helps I'm trying to produce a Matrix like the below:

maracles_0-1648068336515.png


My data is in two tables:

1. Departments
2. Roles

The data relationshipis one to many, with each Role linking to only one Department, but each Department having many Roles.

I just figure out to have the Roles as the value in the table.  Does ConcatenateX help in this scenario? 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.