v1.0.5 - Add row totals are not displaying

[pramod-thaz]

Hi I downloaded the visual from the App Store and used your Demo Finance (Simple P&L) as a guide to prepare an income statement representation. However, when I add the custom rows, the numbers in that row are not displayed. Please advice. See image below

[toresenneseth]

Hi,

It might be that the "numbers" in your data model are strings because you have used some DAX function, for example FORMAT? If the values are not numbers, we cannot do math on them.

[toresenneseth]

Did you manage to resolve this issue?

[pramod-thaz]

Looks like it behaves in unexpected ways when there are more than 1 nested hie

On Sun, Nov 1, 2020, 6:20 AM Tore Senneseth notifications@github.com wrote:

Reopened #158 https://github.com/Profitbase/PowerBI-visuals-FinancialReportingMatrix/issues/158 .

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/Profitbase/PowerBI-visuals-FinancialReportingMatrix/issues/158#event-3945224451, or unsubscribe https://github.com/notifications/unsubscribe-auth/AM6P25UQPURP6Q4DNMTR2S3SNVVCHANCNFSM4SYOBPVA .

[ftmfatos]

HELP HELP HELP!! I've just faced the same problem. It is not because of the data format as toresenneseth said.. The error is occured when subtotals are added the another formula. but i know that this problem appeared just soon, there was no problem in previous months. Maybe it occured after the Power BI update or the apps version. I don't know. As a result I need help :/

[toresenneseth]

Hi,

I think that the reason you are having this issue is probably because of the order of your applied steps. Is the "16-Operational Profit" step before the "25-Profit Before Tax" in the applied steps list?

[ftmfatos]

Thank you for the solution. I reorginized the applied steps and it works. However, I still don't understand why this problem occurred this month. Anyway, thank you again.

[toresenneseth]

The reason why this occurred this month is that a new version was published to AppSource, and it automatically updates all visuals to the latest version (v3). We changed this behavior in version 2, because there were a lot of scenarios we couldn't handle with how it was implemented previously, where all the calculations and subtotals steps were executed first regardless of where they were in the list.

If you don't want automatic updates, you can download the visual from https://www.profitbase.com/powerbi or from https://github.com/Profitbase/PowerBI-visuals-FinancialReportingMatrix/releases and register the visual as an organizational visual in your Power BI admin portal.

When you download directly from us, you will always get the latest version, but no automatic updates.