How to stop Count on X axis values in clustered bar chart?

[husse]

Hi,

I am trying to create a clustered bar chart with;

X axis; EntityName, Text

Y axis: Amount, Decimal

However, each time I try this Power BI automatically puts "Count of EntityName", despite selecting "Don't Summarize" in Column Tools. I even tried creating a new measure but it didn't work.

EntityName NoCount = FIRSTNONBLANK(DimEntity[EntityName], TRUE())

How can I cancel this?

Many thanks!

[Barthel · Accepted solution]

I'm not sure. What is the purpose of your chart? 

Since the y-axis is the dimension for a bar chart and the x-axis the values, Power BI automatically converts the column to a value as soon as you place it on the x-axis (i.e. 'Count of EntityName'). It sees the 'Amount' as the dimension and gives you the number of 'Entities' that have that 'Amount'. 

If you want the sum of the amount per entity, put the 'Entity' on the y-axis and the 'Amount' on the x-axis.

[Barthel]

Hey,

A clustered bar chart shows your values ​​horizontally. So the dimension is on the y-axis and the values ​​are on the x-axis. In this case you should put the Entity on the y-axis and the Amount on the x-axis.

If you want to show the values ​​vertically, you can use the clustered column chart.

[husse]

Hey,

Thanks for your reply. I am very new to Power BI and learning it on an online platform.

This chart belongs to one of the exercises. On the virtual machine of this online platform, I could create this clustered bar chart without any problem. However, when I try it on my own device, it always creates the chart with "Count of EntityName" on the X axis. Therefore, I was wondering if this is related to the Power BI version that I use or any other default settings it might have. 

[Barthel · Accepted solution]

I'm not sure. What is the purpose of your chart? 

Since the y-axis is the dimension for a bar chart and the x-axis the values, Power BI automatically converts the column to a value as soon as you place it on the x-axis (i.e. 'Count of EntityName'). It sees the 'Amount' as the dimension and gives you the number of 'Entities' that have that 'Amount'. 

If you want the sum of the amount per entity, put the 'Entity' on the y-axis and the 'Amount' on the x-axis.

[husse · Accepted solution]

Thank you very much for your reply. I finally understood what caused this problem.

Apparently on the virtual machine vertical axis is named as X axis and the horizontal axis is named as Y axis. However, this is not the case with the version I have on my own device.