third column value instead of total label

[Sanskruti]

Hello everyone, 

I have a power bi report in which i have used a stakced bar chart which shows total loads and total empties. The requirement is instead of total label in the stack chart they want to see the total static capacity (which is another column and it has negative values). 

I added a that column also in that chart but they want to see the total static capacity in place of total label.

Is there any way?

Thank you in advance.

[Kishore_KVN · Accepted solution]

Hello @Sanskruti as we dont have conditional formatting option for the total labels, to the best of my knowledge we can not have totals in that way. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[Sanskruti]

Hey, thanks for replying @Kishore_KVN 
Is there any custom visual which can help me in this?

[Kishore_KVN]

Hi @Sanskruti , There is no custom visual like that as well. If the visual is going to be static and not going to change when any filters or slicers are applied then we can do a temp fix with the help of a card visual placed on top of that lable. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!