Table Visual: How two show two rows if two people have the same name

Question

HiI have an Employee dimension with 2 rows:&nbsp;ID&nbsp; &nbsp; &nbsp;Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Valueid1&nbsp; &nbsp;"Mr Anderson&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1"id2&nbsp; &nbsp;"Mr Anderson&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2"&nbsp;If I show this in a table visual without including the ugly id column,&nbsp; it will display&nbsp;Mr Anderson&nbsp; 3&nbsp;But that is of course not what I want- I want to display the same name twice&nbsp;In Reporting Service, SSAS and every other report-tool know to man, you can define a "key Column" and a "Label Column",&nbsp; for each dimension property, so that you may choose how to handle a situation like this.&nbsp;Please tell me this is possible in Power Bi also!&nbsp;&nbsp;

amitchandak · Accepted Answer

RootOfMinusOne , You need to use the ID(unique column in visual) , or you can try value as not summarized (if they are different)

Forum Discussion

Table Visual: How two show two rows if two people have the same name

2 Replies

Related content

export from visual table

Table visual error

Table Visual not Matching Calculated Visual

How to avoid people creating multiple times the same table in different workspaces

Active people