Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Matrix subtotals issues in api 2.6

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

1 Reply

  • v-evelk's avatar
    v-evelk
    Microsoft Employee

    Hi Fredrik,

     

    I see that you also send an e-mail with the same question to [email protected]

    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
    [email protected]