cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Turn Off Certain Subtotals in Calendar Matrix

Hi there,

 

I have a calendar table that shows me the total spend by month with the upcoming months showing a forecast. I want to differentiate the months I have actual data for from the upcoming (or forecasted) months. So I used column headers to differentiate them like so:

 

Example 2.png

 

 

However, I don't want the subtotals for "Actual" and "Forecast" to appear, but I do still want the grand total at the very right to stay. In other words, I need my column headers to be:

 

Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total

 

with "Actual" appearing over Jan to Sep and "Forecast" appearing over Oct to Dec. Any ideas on how to set this up? I played around with the turn off Column subtotals option, but it also removes the total at the end.

 

Example 3.pngExample 4.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resident Rockstar
Resident Rockstar

Re: Turn Off Certain Subtotals in Calendar Matrix

Hi @abaig,

 

We only could turn off all of the subtotals of column in Power BI Desktop currently.

 

Here is a workaround which also could achieve your desired output.

 

Turn off the Word Warp of Values and Column headers under formatting.

 

Capture.PNG

 

Then please refer to the option in this gif.

 hide subtotal_.gif

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Resident Rockstar
Resident Rockstar

Re: Turn Off Certain Subtotals in Calendar Matrix

Hi @abaig,

 

We only could turn off all of the subtotals of column in Power BI Desktop currently.

 

Here is a workaround which also could achieve your desired output.

 

Turn off the Word Warp of Values and Column headers under formatting.

 

Capture.PNG

 

Then please refer to the option in this gif.

 hide subtotal_.gif

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors