search

Profitbase / PowerBI-visuals-FinancialReportingMatrix

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

Too many values in columns #588

Open mdx-12 opened 8 months ago

mdx-12 commented 8 months ago

Hi Anders,

I have the message "Too many values. Not showing all data " for the period 1-12/2023 but I don't understand why. There are only 12 time periods (months) and max 5 departments groups (+ total) for each month in columns, it means max 12*6= 72 columns. There are only arround 450 rows in my report. As far as I know, limitations for your matrix visual are 100 columns and 3000 rows. Could you please help me ? Thanks in advance.

Image

AndersAano commented 7 months ago

Hi @mdx-12 ,

Sorry for the late reply. It could still be that you face a limit when it comes to the amount of data.

The different fields you have on your Rows. Are they related to each other, or will each item in "L1 popis" be repeated under each item from ReportLine JSON?

What I mean by a relationship is that the items from "L1 popis" are sorted under different Parent headers.

image

If there's no relationship, like in the example below, you get a lot of rows due to repeating items:

image

-Anders

mdx-12 commented 7 months ago

Hi Anders,

Thank you for your response. There's a relationship between "ReportLineJSON" and "L1 popis" dimensions, it's a "parent-child" hierarchy so there aren't any repeated items. Similar to your first example above. That's why my question ...