Gradient coloring by sum not count

[Anonymous]

Hi,

I wanted to color gradient my column chart. I used the feature before and quite like it. However, when I tried to use it this time I've encountered a problem I've not before. As you can see, in the summarization screen I see only count & count(distinct) but no sum. I need to use the gradient calculated by sum.

I tried bar chart as well, it didn't work. Neither did changing column summarization to don't sum and sum back and forth. Thanks in advance.

[amitchandak · Accepted solution]

@Anonymous , Check if the column is of text type.

Create a measure what you need

example

measure = sum(Table[Value])

and use that