Forum Discussion

kettsn's avatar
kettsn
Frequent Visitor
4 years ago
Solved

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 l...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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