cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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.

amitchandak
Super User
Super User

I get the error for the "Measure" creation

alisonpappas_0-1642621305042.png

 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors