Change the columns name on a chart

[leonardo_roque]

Hello
I have a table on excel with the ID of a worker, his name and how many hours he has worked. However there are people that has the same name.

When I create a chart in power bi and I use his ID in the axis, it appears his ID on the chart. Is there any way, where choosing ID in the axis, it would appear his name on the chart?

I tried using ID and name as axis, and then I tried drill down(or show the next level). However since the names are the same, it only appears one column and the sum of the hours they have worked

If I expand to the next level, it appears the ID and the name. But I don't want the ID to be there


What can I do to use ID as the primary axis, but showing the name of the worker? Is it possible?

Thanks for the help

[amitchandak]

Put the name of axis and id on tooltip and try.

[leonardo_roque]

It appears as one column with the sum of the two workers. And on the column, it shows only one ID( I get to choose if the first or the last one)

[amitchandak]

Not sure if you want to do so.

ID name = [ID] & " " & [Name]

[leonardo_roque]

Thanks for trying to help me.
What I want is just the name to appear in the chart. However, if I use Name on the axis, there might be a problem since we have people with the exactly the same name. So, my intention is to sort by ID (which if unique), but I don't want the ID on the chart, I would like to see the Name.

[v-xuding-msft]

Hi @leonardo_roque ,

You could try to create new groups to change  the name like below.

Reference:

Use grouping and binning in Power BI Desktop 

If there are lots of data and it is impossible to change name one by one manually, maybe you could reference the videos and blogs to try transforming data and using a slicer to implement it.

Dynamically change chart axis in Power BI

Power BI - Dynamic Axis via Slicer (No DAX)

Dynamic X axis on charts – Power BI 

https://www.kasperonbi.com/dynamically-switching-axis-on-visuals-with-power-bi/

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[leonardo_roque]

Hi @v-xuding-msft,
Thanks for the reply. That could help me. However, since I have 100000 lines, that would take some time. It would be better if it was dinamically.
Thank you anyway.

[v-xuding-msft · Accepted solution]

Hi @leonardo_roque ,

Well, can the links above help you? If not, maybe you could try to create a custom tooltip as a workaround. While the mouse hovering over the chart, the tooltip will show name automatically, like this:

Reference:

Create tooltips based on report pages in Power BI Desktop 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.