Cannot get Power BI to stop summarizing data

[toniacheung]

I'm trying to make a stacked column chart of the number of actions that were due in 7 days or overdue over time.  The table I'm using is a calculated table I made from two other tables because one table had the historic data and the other had the formula I wanted to use to calculate this in the future.  The data type and format for the columns are set to Whole Number.  I have the Default Summarization for the columns set to Don't Summarize.  But when I try to put my data in a stacked column chart (or any kind of chart, actually), it puts them in as a Count, and there is no option on the drop down to stop summarizing the data.  (The option to turn off summarizing is there if I wanted a Table visual, which I don't.)  How can I make it stop summarizing my data?

[v-frfei-msft]

Hi @toniacheung ,

For the Stacked column chart, the value is summarized by Axis by default. We can put the column in Axis it to legend as well to work around. If it doesn't meet your requirement, Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.