cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alisonpappas
Helper III
Helper III

Add Grand total to a clustered bar chart

Hello,

 

I have a data set that i am trying to add a grand total column to a chart. it would sum up each bar and be it's own. any advice on how to do so?

alisonpappas_0-1642606622997.png

 

3 REPLIES 3
v-xiaotang
Community Support
Community Support

Hi  @alisonpappas 

According to the error prompt, you should convert string to value before calculation. Try function such like Value().

vxiaotang_0-1643004019940.png

If this doesn't help, please provide more details, so that we can work on,

(1) a sample file, you can replace raw data with bogus data to protect your privacy.

(2) or provide some sample data that fully covers your issue/question

(3) give your expected result based on the sample you provide

Kindly note: Please ensure the data in sample is concise and representative.

Thanks.

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

I get the error for the "Measure" creation

alisonpappas_0-1642621305042.png

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors