Forum Discussion
Calculated Column automatic summation in visual
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?
3 Replies
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
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!
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
