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...
  • 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