Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Thanks for suggestiosn .
Solved! Go to Solution.
@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], ",")
@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)
@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:
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |