cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
i820017
Helper I
Helper I

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.

i820017_1-1603654460565.png

 

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

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

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

amitchandak_0-1603675910285.png

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
amitchandak
Super User IV
Super User IV

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

amitchandak_0-1603675910285.png

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

It worked...thanks!!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.