Forum Discussion

AgwaJeff's avatar
AgwaJeff
New Member
3 years ago

HOw to fix my X axis

Hi guys .I'm a new student of power bo and i need help on how to fix my x axis on any visualization it keeps on either getting the sum or count even when i click on don't summarize.what might be the issue?

3 Replies

  • AgwaJeff When you are visualizing the data, it uses aggregation, like SUM/AVERAGE/COUNT, if it is a text field, it will use count and can be changed to other aggregations but you cannot have non-summarized data on the value axis.

  • This is because of the type of graph that you've selected - the x axis will need to be aggregated somehow. I'm not sure what your end goal is, but you could swap the values in the x and y axis, or select a different type of visual such as a matrix?