Forum Discussion
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
@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.
2 Replies
- amitchandakSuper User
@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.- i820017Resolver II
It worked...thanks!!