How to group the values in a column and display it as another value in the same column.

[AnandNamburi]

Hi All,

I have a report like below.

My requirement is to group all the values of A,B,C,D,E,F AS Industry and showing the sum of all gainst it. and need to displat the Industry along with A,B,C,D,E,F,Industry

Example:

A-10,B-5,C-40,D-15,E-20,F-5

A-10,B-5,C-40,D-15,E-20,F-5,Industry-95

How we can acheive this?

Thanks,
Anand

[v-jingzhang]

@AnandNamburi

Have you tried the solutions in above reply? If it has solved your problem, please mark it as a solution. You can also share your own solution if you have different ideas. Otherwise if you are still confused about it, please provide more details about your problem. Thanks a lot.

Best Regards,
Community Support Team _ Jing Zhang

[amitchandak · Accepted solution]

@AnandNamburi , refer this past solution

https://community.powerbi.com/t5/Desktop/Grand-Total-in-Bar-Chart/m-p/612631

or

https://www.reddit.com/r/PowerBI/comments/976zay/how_to_show_grand_total_on_a_clustered_bar_chart/