Hidden rows when I filter date range

[albarval]

Hi In our company we are happy with your app for our financial reports. Unfortunatelly, we have detected a bug, as you can see on the screenshots, on the left you can see all the accounting groups but after applying date filters selecting just October 2022 (see on the right) some rows has disapeared i.e. groups number 3,4,5 and 7.

This makes we cannot use any filter if we want to see all the rows. Can be fix in next version and when is planned please?

[AndersAano]

Hi,

Please take a look at this video that explains what is happening, and how to prevent it: https://www.youtube.com/watch?v=Z_RPrjEktcM&list=PLIKjDnkaTRYxmEMX0kb_zRcfVMYRTruD0&index=4&t=130s&ab_channel=Profitbase

Best regards Anders

[albarval]

Hi Anders,

Thanks for your answer. I saw the video and have now activated the option “show items with no data”. Is working just if I have one field “Account groups” in rows but not if I add the second level of rows “Account_code”(See Image 1) . The purpose is to be able to show all the Account_groups and account_code inside each group (Image 2). In the video you commented the feature created to show only accounts with value maintain ALL groups, in my case I don’t mind show all accounts but I need to maintain static the structure of all groups. Can be possible?

Image1 @.***

Image2 @.***

Thanks Alberto

From: Anders Aano @.> Sent: Monday, September 25, 2023 1:21 PM To: Profitbase/PowerBI-visuals-FinancialReportingMatrix @.> Cc: Alberto Bartolome Vallejo | ProvenExpert.com @.>; Author @.> Subject: Re: [Profitbase/PowerBI-visuals-FinancialReportingMatrix] Hidden rows when I filter date range (Issue #523)

Hi,

Please take a look at this video that explains what is happening, and how to prevent it: https://www.youtube.com/watch?v=Z_RPrjEktcM&list=PLIKjDnkaTRYxmEMX0kb_zRcfVMYRTruD0&index=4&t=130s&ab_channel=Profitbase

Best regards Anders

— Reply to this email directly, view it on GitHubhttps://github.com/Profitbase/PowerBI-visuals-FinancialReportingMatrix/issues/523#issuecomment-1733468993, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BCWW5AXDIRWJ463B435R6J3X4FSKZANCNFSM6AAAAAA5ACYUJI. You are receiving this because you authored the thread.Message ID: @.**@.>>

[AndersAano]

Hi @albarval,

The images are not included if you reply by email. Please follow the link to GitHub, and add the images directly there for me to see them.

Best regards Anders

[albarval]

oh sorry for that, please take a look here:

Hi Anders,

Thanks for your answer. I saw the video and have now activated the option “show items with no data”. Is working just if I have one field “Account groups” in rows but not if I add the second level of rows “Account_code”(See Image 1) . The purpose is to be able to show all the Account_groups and account_code inside each group (Image 2). In the video you commented the feature created to show only accounts with value maintain ALL groups, in my case I don’t mind show all accounts but I need to maintain static the structure of all groups. Can be possible?

Image1

Image2

Thanks Alberto

[AndersAano]

Hi @albarval,

If you can send me an email at pbi.visuals@profitbase.com, we can schedule a meeting and look at this over Teams.

Best regards Anders

[albarval]

Thank you Anders! I sent you an email

Regards Alberto

[albarval]

HI Anders! Thank you for your availability and quick solution. I appreciate your help to sort it out the issue on my data model.

Regard Alberto