Show the total in Data Labels

[msantillan]

Hi, is it possible to show the total of both columns in this bar chart.

Is it possible to show the combined values of the pre-percentage and the percentagepositive as the data labels? (ie. bar1=102.24%, bar2=101%.. etc), without having to edit the nature and the look of the graph. As I want to show the user the values with greater than 100% in a different color.

[v-frfei-msft · Accepted solution]

Hi @msantillan ,

We can use Column chart with variance to work around.

Pbix as attached.

[msantillan]

Why does it appear like this when I apply it to mine?

[v-frfei-msft]

Hi @msantillan ,

You should add the measure to the plan and add the value to the actual.

[msantillan]

Hi, it still appears unchanged

[v-frfei-msft]

Hi @msantillan ,

Kindly share your Pbix to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[msantillan]

@v-frfei-msft 

Unfortunately, I can't send any files using my corporate PC. It still doesn't work on my end. I would like to know how you use this calculated column below:

Also, would like to know how you added a dotted line in the 100% here: