cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Showing multiple text values in a matrix

Hey all, I'm trying to use PowerBI to create a 'nine-box' report - basically, a matrix where you have 'performance' on one axis, 'potential' on the other axis and then you have names of individual employees in each box based on their performance/potential ratings.

 

In PowerBI, I can create a matrix that will display the first name in each box, but I can't figure out if there's a way to use the Matrix visualization to display every value that matches the criteria for that box in the matrix. Any ideas on how I can do this? Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Showing multiple text values in a matrix

Hi @maronis,

Create a measure in your table using DAX below.

Measure = CONCATENATEX (VALUES(Table1[Employee Name]), Table1[Employee Name], ", ")

Then create Matrix visual as shown in  the following screenshot and you will get expected result.
1.PNG

 

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
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

9 REPLIES 9
Highlighted
Microsoft
Microsoft

Re: Showing multiple text values in a matrix

Hi @maronis,

Could you please share sample data of your table and post expected result here?

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper I
Helper I

Re: Showing multiple text values in a matrix

Absolutely. So I'm hoping to take data that looks like the below where there is a Performance rating and Potential value for each employee:

Source data.jpg

And the output should be a matrix that looks something like below, where Performance is on one axis, Potential is on another axis, and all values for each box in the matrix are populated.

 

Output.jpg

 

Thanks so much for your help!

Highlighted
Microsoft
Microsoft

Re: Showing multiple text values in a matrix

Hi @maronis,

Create a measure in your table using DAX below.

Measure = CONCATENATEX (VALUES(Table1[Employee Name]), Table1[Employee Name], ", ")

Then create Matrix visual as shown in  the following screenshot and you will get expected result.
1.PNG

 

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
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

Highlighted
Helper I
Helper I

Re: Showing multiple text values in a matrix

Awesome, thanks so much!

Highlighted
Super User I
Super User I

Re: Showing multiple text values in a matrix

Highlighted
Super User I
Super User I

Re: Showing multiple text values in a matrix

@v-yuezhe-msftI ran into a similar problem and then found this post which solved my problem. I wanted to see how far dyanmic this formula is and it surprised me.

 

I created a sample table to tase it on two CATs and it succedded in both the cases.

 

Capture30000.PNG

I was wondering if you can please shed some light on this to help me understand how does the formula works on parts. It is simply great. I fail to understand how the formula slices up values based on the different CATs

Highlighted
Anonymous
Not applicable

Re: Showing multiple text values in a matrix

Hello, 

 

How can I add a line break in between values instead of having them all on the same line?

 

 

Capture.PNG

 

Highlighted
Anonymous
Not applicable

Re: Showing multiple text values in a matrix

Solved by adding UNICHAR(10):

 

Measure = CONCATENATEX (VALUES(Merge1[Assignments.ProjectName]),Merge1[Assignments.ProjectName], UNICHAR(10))
Highlighted
Helper I
Helper I

Re: Showing multiple text values in a matrix

Thanks for this! Is there a way to do this DAX, but also add an addition text field next to the name? For instance, the result would look like:

"NAME" + "another field with additional info"

 

I was thinking the DAX could look something like: Measure = CONCATENATEX (VALUES(Table1[Employee Name]), Table1[Employee Name] + (Table1[Additional Info]), ", ") -- this doesn't work, but is something similar to this possible?

 

Thanks!

Nicole

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors