Matrix subtotals issues in api 2.6

[Anonymous]

Hi,

Have anyone got the new (https://powerbi.microsoft.com/sv-se/blog/power-bi-developer-community-april-may-update/#sdk-updates) subtotals feature to work properly with api 2.6? For me it behaves very strange. First of all I need to name the dataRoles properties to "Category", "Column" and "Measure" (regardless if I reference them that way in the dataViewMappings) - anything else will not give me any subtotals at all. Secondly, I only get a maximum of 100 rows back when using subtotals, regardless of what I specify in the dataReductionAlgorithm.

There is a sample matrix visual with subtotals here: https://github.com/Microsoft/Powerbi-Visuals-SampleMatrix. However, that one is not built for the new api.

Anyone with the same problem or maybe a solution to it?

/ Fredrik

[v-evelk]

Hi Fredrik,

I see that you also send an e-mail with the same question to pbicvsupport@microsoft.com

As soon as our developers provide a solution or info, I will share it here too.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com