How to Add a total column in a clustered column Chart?

[Adamp1916]

I know this question has been asked alot...  I've been searching through and trying every "solution" for hours but nothing actually works.  Once again, WHY is such a simple task SO HARD?  I feel like every time I try something in power BI, I just laugh and want to go back to excel because it doesn't have anywhere close to as many problems with simple tasks that should take seconds.

I have a clustered column chart that shows projected future dollar pay outs by quarter.  I won't get into how ridiculous it was to get these to actually display in chronological order....  All I want to do is have a column at the beginning that shows the total dollars.  The closest I could get was having two separate charts and grouping them together, but that looks really bad.  Every other solution posted here either has multiple variables or just adds multiple total columns next to each existing column and basically duplicates it...  I just want a column at the beginning that shows the total dollars.

[Aburar_123]

Hi @Adamp1916 ,

Please add the total column as below. Sales_Discount is giving the total of Sales & Discount

Sales_Discount = SUM(FACT_Orders[Sales])+SUM(FACT_Orders[Discount])

[ryan_mayu]

@Adamp1916 

Ususally we don't display data like that. We like to use drill mode in powerbi

https://learn.microsoft.com/en-us/power-bi/consumer/end-user-drill?wt.mc_id=DP-MVP-5004616

So that will not also the total and quarter data display at the same time.

If you have to do that, pls provide some sample data and we will provide you the workaround for it.

[Adamp1916]

who is "we"?

It's extremely common to show a total column in a data set.  Sample data would just be a column with random amounts in it next to another column with different quarters.

[v-aatheeque]

Hi @Adamp1916 

• As per the word " we ” (which just meant the general Power BI community/common approach in Power BI).
  
  
• you’re right that many scenarios require displaying both totals and quarters together. To help suggest a suitable workaround for your case, could you please share a small sample dataset.
  How to provide sample data in the Power BI Forum - Microsoft Fabric Community
  
  

[FBergamaschi]

As you say, this is not easy with standard colum charts

My suggestion is to go to the marketplace (... under the icons of the visuals) and check for other column charts that include totals in automatic

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI