cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

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.

Top Solution Authors
Top Kudoed Authors