Bar Chart Visual will not accept a column

[vb55]

I am trying to create a stacked bar graph in Power BI. The X-Axis is a date column and the visual accepts this.

The Y-Axis is a monetary value (called Amt) - the column is a Whole Number type. It is not summarised. The visual will just not accept the Amt column.

I have tried changing data types (decimal, currency) with no luck. I have checked if there are any null or blanks in the column and there aren't any. What am I doing wrong?

Any help highly appreciated.

[Anonymous]

Hi @vb55 ,

Is there any error message?

Best Regards,

Jay

[vb55]

How do I send the PBIX - the editor on the forum does not allow me to attach files !  So sorry for this

[amitchandak]

@vb55 , You have add use default summarization

or

create a new measure

= sum(Table[Amt])

[vb55]

Thank you so much for such a swift response - I forgot to mention that I had tried that as well but no luck 

[amitchandak]

@vb55 ,
Can you share a sample pbix after removing sensitive data.