Forum Discussion
Power Bi charts
I am wanting to make my chart based on names. I have 3 people with the same name and it is adding them up as the one person in a colum chart. How do I change this. We have a customer ID but I would like to see the name of person instead of customer ID in the chart.
Hi kettsn ,
Add both Name and ID to the Axis field of the chart and click "Expand all down one level in the hierarchy".
Or create a calculated column and use this column as Axis.
Name&ID = 'Table'[name]&"_"&'Table'[id]Best Regards,
Jay
3 Replies
kettsn , if possible add both , Other than table visual use expand icon (reverse square Y) and both will be show
Or create and appended column of id and name and use that in visual
hi amitchandak
Where is expand icon located and the reverse Y.
Hi kettsn ,
Add both Name and ID to the Axis field of the chart and click "Expand all down one level in the hierarchy".
Or create a calculated column and use this column as Axis.
Name&ID = 'Table'[name]&"_"&'Table'[id]Best Regards,
Jay
