Column SubTotals

[i820017]

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

[amitchandak · Accepted solution]

@i820017 , In the subtotal you have the option - Subtotal - Column by level, Check if that can help

Provide your feedback and tips for new videos
Dax Series Tutorial Vs SQL Direct Query PBI Tips
We appreciate your congratulations.

[i820017]

It worked...thanks!!