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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ltns
Employee
Employee

Show Name Instead of ID in Matrix

Hello,

I'm working with a Power BI matrix, and I'm looking to group rows based on their IDs. However, I'd like to display the associated names instead of the IDs themselves. Is there a method to achieve this?

ltns_0-1694685111632.png

Thank you!

9 REPLIES 9
Kopek
Helper IV
Helper IV

Hi, have you found a solution to this issue ?
sergej_og
Super User
Super User

As Idrissshatila suggested,
place name first and on second place the ID.
Through the ID names are displayed separately then.

Otherwise show pls your target result.
What do you want to see?

@sergej_og @Idrissshatila  I am targeting to see something like this; it should group by id but it should show name instead of id

ltns_0-1694688085313.png

this is how I grouped rows: 

ltns_1-1694688116590.png

 

Idrissshatila
Super User
Super User

@ltns , then add the ID and the name and drill down the visual to show both.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Displaying the ID is not the preferred choice; I simply need to display the name. Is there a workaround or tip to achieve this?

@ltns , if as you said the name is not unique then you need a column that make it show the unique value without aggregating the data.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




I have added id end of the name column and hided it in matrix but now it shows "..." end of the line. Also it shows id in tooltip when cursor on that line 

ltns_1-1694687088235.png

 

Idrissshatila
Super User
Super User

Hello @ltns ,

 

replace the name column instead of the ID column.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




name column is not unique, then it aggregates all name columns with same names

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors