Calculated Column automatic summation in visual

[bonus1]

Hey guys,

I created a calculated column in Power BI. If I display this in the visual "table" it is possible to set the column as "Do not sum". But if I display it in the visual e.g. clustered column chart, it sums it automatically, and I can't choose "Do not sum".

That is a problem for me.

Do you have any ideas to solve this issue?

[v-jiascu-msft]

Hi @bonus1,

What's issue with your scenario?

If the data is unique, the sum just act as the "Do not sum".

If the data isn't unique, how can we show them in a column? For example, 

Color    Value

Red       100

Red       200

How can we show the value in the "Red" column?

Best Regards,

Dale

[bonus1]

Hi @v-jiascu-msft,

the scenario is the following:

Column Value (calculated column) is formatted as "do not sum"

Visual Table:

Color   Value

Red       100

Red       100

Blue      200 

Blue      200

Blue      200

Yellow   500

Yellow   500

Now I want to use a Visual: clustered column chart and want to display on the x Axe the Color and on the Y Axe the Value, but the unique value, the distinct of the column Value. The Result should be:

                         500 -----

            200 ----

100 ----

       Red     Blue     Yellow

Do you understand my problem?

Thank you very much!

[v-jiascu-msft]

Hi @bonus1,

If you can make sure the values are the same, I would suggest you create a measure instead.

Measure = SELECTEDVALUE(Table1[Value])

Best Regards,

Dale