Turn Off Certain Subtotals in Calendar Matrix

[Anonymous]

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:

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.

[v-piga-msft · Accepted solution]

Hi @Anonymous,

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.

Then please refer to the option in this gif.

 

Best  Regards,

Cherry