how to avoid axis of chart combine same value?

[danielllin]

Hi,

i can't describe whole question in subject, so i use this example to explain.

on the right side, in this data, both of emp0004 and emp0008 are Daniell

two of them are different person but have same name

if i use bar chart, how can i avoid emp_name combine automatically?

or how can i use emp_id as y-axis, but shows emp_name value instead of emp_id?

Thanks in advance!

[danielllin · Accepted solution]

Thanks for replying.

I can't use white box to cover id, because length of id are dynamic in different company,

but first step is considerable, it's almost same effect as creating a new column to combine id & name, i will use this method if there are no other better and proper way. 

[MattAllington]

Maybe a bit of a hack, but try putting both Id and name on the axis, then drill down using the button to maintain hierarchy (the 3rd button moving left to right on the top left corner of the chart, the one with the horizontal bar above the down arrows). Then hide the ids under a white box

[danielllin · Accepted solution]

Thanks for replying.

I can't use white box to cover id, because length of id are dynamic in different company,

but first step is considerable, it's almost same effect as creating a new column to combine id & name, i will use this method if there are no other better and proper way. 

[v-yuezhe-msft · Accepted solution]

@danielllin,

I  think that the best approach is to create a calculated column to combine emp_id and emp_name.

Regards,
Lydia

[danielllin]

I see, thanks!

[williamdlupo]

Has anyone found a correct (non-hack) method of doing this in Power BI? Our customer Id's are sensative and absolutely cannot be concatenated to their values, but we don't want to automatically "group" equal values.