topic Total and subtotal API in Custom Visuals Development Discussion

Total and subtotal API

danieleperilli — Thu, 26 Sep 2019 15:59:24 GMT

Hi everyone,

After reading this article https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-april-may-update/, I tried to implement the Total and Subtotal API in my project.
I changed the data mapping to Matrix, added the subtotals properties in the capabilities.json and inspected the returned dataViews object in order to find the total property or something like that, I don't know what I have to expect.
Unfortunately, after hours of tries, nothing appeared in my model.

So, I tried your suggested project (Powerbi-Visuals-SampleMatrix) but the result is the same, I can't find anything in model related to totals or subtotals (and yes, I enabled the relevant options :).
Here are a couple of screenshots to clarify my issue:

The matrix-like visual that doesn't include totalsA portion of the returned model

Thanks,

@v-viig, @v-evelk

Re: Total and subtotal API

v-evelk — Mon, 30 Sep 2019 14:45:42 GMT

Hi,

Could you please send your report and visual code for analysis to pbicvsupport@microsoft.com ?

Kind Regards,

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

a Re: Total and subtotal API

George_keldawi — Mon, 17 Aug 2020 08:00:52 GMT

hi, a fix for this issue has been deployed, and the issue should be fixed, i tried it tody and i do have subtotals and totals on my visuals.

please try for yourself and replay if you are still having this issue.