Matrix - Subtotals Menu - Apply to Labels - Does NOT work

[Sean]

The Apply to Labels option in the Subtotals Menu for a Matrix Visual Does NOT work.

This Option has in fact never worked since it first appeared in the Matrix Preview!

See this post from 06-13-2017 (over a year ago)

http://community.powerbi.com/t5/Desktop/Some-June-Update-features-not-working/m-p/193240

Just tested in the July 2018 PBI Desktop and still no luck

Version: 2.60.5169.3201

Published: 7/22/2018

Hopefully you guys can address this soon

Thanks!

[v-qiuyu-msft]

Hi @Sean,

Would you please share a pbix file with us? Thanks. 

Best Regards,
Qiuyun Yu 

[Sean]

@v-qiuyu-msft 

Thanks for looking into this! 

The Issue can be demonstrated with any Matrix even a very simple one.

1 Table - 3 Columns

State, City, Value

California, San Francisco, 100

California, Sacramento, 200

California, San Jose, 300

Texas, Austin, 300

Texas, Houston, 100

Texas, Dallas, 200

Here's what happens.

First I show that when you turn on Apply to Labels for the Grand Total all works fine.

Then when we go to the Subtotals and change the background all works so far as well...

But now when you click Apply to Labels for the Subtotals as you can see - nothing happens!

The Subtotal Labels DO NOT change at all

In the Example the California and Texas Labels do no change to match the formatting applied.

Thanks again for looking into this! 

[v-qiuyu-msft]

Hi @Sean,

Thanks for your detail reproduce steps. I have reported this issue internally: CRI 78603008. Will update here once I get any information. 

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft]

Hi @Sean,

This is by design. In stepped layout, "California" and "Texas" are not subtotal headers, they are normal headers. They are not formatted as Subtotals. Note that their text is not bolded.

Best Regards,
Qiuyun Yu 

[JoelPendery]

Is it possible to have the labels of the subtotals (in the example California and Texas) take on the formatting of the subtotals? Currently, when you click the Subtotal Labels switch, it highlights the Grand Total Label instead. I just downloaded the most recent version - Version: 2.62.5222.761 64-bit (September 2018)

[v-qiuyu-msft]

Hi all, 

Update: we have decided to change the behavior and apply Subtotal styles to Row Headers that are not on the last level.

The change will come in October release.

Best Regards,
Qiuyun Yu 

[trevor]

Hooray!  When can we expect the October release?