Stacked column chart with a GT?

[Joe_Grosskopf]

I have a report using the stacked column chart..works great. it shows each users time used over a given date range. The manager would like to a see another column at the end showing all the users combined as a GT. Is there a way to make one column a GT of all the data?

[Joe_Grosskopf]

Thank you...I think I"m making progress but I'm not quite understandingmy summarize statment. I have this:

Table = SUMMARIZE('Query1','Query1'[Non-Dir],"All-Util",max('Query1'[date_entered]),summarize('Query1',Query1[General],"All-Util","Gen"))

and am getting an error expects column name in arg number 5

What I'm hoping to achieve in this table is

Date Entered | Non-Dir | Gen

1/1/2022       |  10         | 40

1/2/2022       | 8            | 26

1/3/2022       | 15          | 50

Etc.

[amitchandak]

@Joe_Grosskopf , I have given a solution for bar, check if similar can work for stacked

https://amitchandak.medium.com/power-bi-add-grand-total-row-in-the-bar-visual-44c3d1d463be

[Joe_Grosskopf]

I managed to get it working but one of the columns I wish to GT is a calculated column and it's just giving me NaN.....is there a way around this?

[v-easonf-msft]

Hi, @Joe_Grosskopf 

Can you share a sample file for further research？

Best Regards,
Community Support Team _ Eason