Forum Discussion

i820017's avatar
i820017
Resolver II
5 years ago
Solved

Column SubTotals

Hey Everybody,

 

I am working on a weekly 2020 report that organizes each week by the month that the week is in.

Anyway, I am having difficulty removing column subtotals. As you can see below, my Power BI report is totaling per month and per year.

 

I only want this report to total per year, not per month. When I turn off the Column Subtotals in the Format paintbrush under Visualizations, all of the column subtotals are removed. 

How do I turn off the monthly column subtotals without turning off the column subtotals for the whole year?

Thanks

Dan