search

Profitbase / PowerBI-visuals-FinancialReportingMatrix

Power BI Custom Visual for Financial Reporting
66 stars 23 forks source link

JSON Rows disappear after Slicing #557

Closed moueedhassan closed 3 months ago

moueedhassan commented 3 months ago

My JSON file looks like this: image

The row fields are set to show items with no data and my report looks like this: github issue

Issue: some of the rows disappear at random after filtering for company, for e.g. in the one above we do not have gross margin % anymore, sometimes other fields disappear too. I have tried all the solutions in https://github.com/Profitbase/PowerBI-visuals-FinancialReportingMatrix/issues/218 like always show JSON rows, RowLevel>0 and everything else.

Please help!

AndersAano commented 3 months ago

Hi @moueedhassan,

Could you send me an email at pbi.visuals@profitbase.com, and we can schedule a quick call to look at this.

Best regards Anders

AndersAano commented 3 months ago

Based on a teams call, it seems the issue was related to the data model. Changing the model to a star schema should solve this issue. Waiting for feedback to confirm,

JeanDeLaColline commented 1 month ago

Hi @AndersAano,

I'm encountering the same issue and have initiated a new discussion on the forum: https://github.com/Profitbase/PowerBI-visuals-FinancialReportingMatrix/issues/594

Unfortunately, I haven't found any solutions that address this problem. To be honnest, it's becoming quite frustrating because the ability to display custom rows in a P&L isn't just a nice-to-have feature; it's essential. Currently, this unresolved issue makes it challenging for me to persuade my client to invest in this visual.

Could you please provide some assistance or feedback on this matter? Your help would be greatly appreciated.

Thank you very much in advance.

John"

JeanDeLaColline commented 1 month ago

Following the last comment in the discussion before it was closed, I would like to clarify that in my case, I am indeed using a star schema.