Simple Bar Chart

[jtownsend2266]

Hello,

New to Power-BI. I have data already summarized (6 columns) from a SQL stored procedure and would like to display it as a simple bar chart but when I add my columns rather than showing the numbers, IE: 20,000, 80,000, 100,000, it shows the count of each column. How can I get it to show the data from the table and not the count of each column?

[grantsamborn]

For each numeric column, try setting Summarization to None.

[MFelix · Accepted solution]

Hi @jtownsend2266 ,

If you are getting the count believe that you have the incorrect format, go to the power query and change the data types to number in those columns, then on your visual chose the SUM has the summarization.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-types

[jtownsend2266]

That was it. Thank you!