Malfunction with multiple levels in columns

[mihergar]

Hello

I think the visual does not work correctly when there are several levels in columns.

I attach an example image.

The first one using the standard Power Bi matrix visual.

The second one using ProfitBase.

As can be seen, the data for TA0 shown by ProfitBase is incorrect, for the financial year 2019 it shows the data for 2020 and leaves the data for 2020 empty.

If more financial years are added, the same thing happens, the data is shifted: in 2019 it shows the data for 2020, in 2020 the data for 2021 and 2021 remains empty.

However, the data for company SZ0 is correct for each year.
Thank you and best regards

[AndersAano]

Hi @mihergar,

Thanks for getting in touch. I'll take a look at this, but I would need some more info:

Could you also add a screenshot of the layout:

And are both Years and Companies from separate dimension tables, or directly from the fact table?

[AndersAano]

@mihergar, is your values from a measure, or straigt from a values field?

-Anders

[mihergar]

hi @AndersAano
Attached is an image of the data layout

Both years and companies come from dimension tables.
The values come from a measure.

[AndersAano]

Hi @mihergar,

If possible, it would be great if you could send me the file on pbi.visuals@profitbase.com.
Then I can troubleshoot your file, and figure out what's going on, cause I'm not able to recreate this issue..

-Anders

[mihergar]

Hi @AndersAano
The file is too heavy, but I try to reproduce the model in another file with less data to send it to you.
Regards

[mihergar]

Hi @AndersAano

I have already sent you to pbi.visuals@profitbase.com the file with the model.

Thank you and best regards

[AndersAano]

Hi @mihergar,

I have finally been able to find something that works for your report.
The issue is something we are currently working on to fix permanently. But before the next version with the fix is out, I have some workarounds that can work for you.

Do you have a license for the visual?
Workarounds work for both free and premium version, but the free one is a bit more complicated..

-Anders

[AndersAano]

[mihergar]

Hi @AndersAano
I don't need that functionality at the moment, I can wait for you to fix it permanently. I sent the message to let you know about the problem and you can fix it.
In the image you sent, it doesn't look like the problem was solved. For company TA0 the same amounts appear for the years 2021 and 2022, which is incorrect.
Thank you!
Regards

[AndersAano]

Hi @mihergar,
We have a fix for this now. It will be part of the next version.
Unless we find any major bugs, we'll release it to GitHub this week as a Beta version.

-Anders

[mihergar]

Hi Anders Thank you very much for the tip. I will give it a try. Regards De: Anders Aano ***@***.***> Enviado el: martes, 20 de diciembre de 2022 13:22 Para: Profitbase/PowerBI-visuals-FinancialReportingMatrix ***@***.***> CC: mihergar ***@***.***>; Mention ***@***.***> Asunto: Re: [Profitbase/PowerBI-visuals-FinancialReportingMatrix] Malfunction with multiple levels in columns (Issue #433) Hi @mihergar <https://github.com/mihergar> , We have a fix for this now. It will be part of the next version. Unless we find any major bugs, we'll release it to GitHub this week as a Beta version.

…

-Anders — Reply to this email directly, view it on GitHub <#433 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/AG6NP5URSTIBGKUCIE3RIFDWOGQHFANCNFSM6AAAAAARX5NZIM> . You are receiving this because you were mentioned. <https://github.com/notifications/beacon/AG6NP5SVL55EOYV2P6JYP3TWOGQHFA5CNFSM6AAAAAARX5NZIOWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTSRAT4VA.gif> Message ID: ***@***.*** ***@***.***> >

[AndersAano]

Hi @mihergar ,

This should have been fixed with v7.0.1 which is currently out.
Could you confirm, and if so, close the issue?

If not, let us know if you still experience the same issue.

-Anders

[AndersAano]

@mihergar this should be fixed now with there release of the latest version.
Could you check if it works for you?

-Anders