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 col...
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