Matrix subtotals issues in api 2.6

Anonymous — Wed, 19 Jun 2019 12:30:25 GMT

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

Re: Matrix subtotals issues in api 2.6

v-evelk — Thu, 20 Jun 2019 15:10:58 GMT

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

topic Matrix subtotals issues in api 2.6 in Custom Visuals Development Discussion

Matrix subtotals issues in api 2.6

Re: Matrix subtotals issues in api 2.6