capabilities.json | Possibility to render more than 200 columns

[DmytroKurhan]

Hi everyone! We use matrix dataMapping structure in our custom visual and we faced with problem of Column Totals: PowerBI doesn`t return the whole columns structure for the last column at right side (including total).

The key problem is that with so many levels of hierarchy, we have over 200 columns coming out at the bottom level and PowerBI truncates the extra columns. As a result, for 2021 we only get 4 months instead of 12 months and no Total

But if we use the slicer and manually trim only column 2021, then we won't have so many columns at the bottom level and PowerBI will return the correct data for each of them. In the screenshot we can see that for the same 2021 year (using the slicer) we have returned columns for each month and Total:

By performing the same experiment, but using the standard Matrix from PowerBI we managed to render all columns with the same hierarchy:

Question: is there any way to manually significantly increase the maximum number of columns that PowerBI will return for rendering ? Setting here a value higher than 200 does not change anything

@dm-p , could you help me with it? Or any idea? 

[dm-p]

Hi @DmytroKurhan,

You have reserved 3000 x 200 data points, which exceed the standard limits for visuals. To allow more data, you will need to use additional data fetching (window) and manage this via your visual logic.

You can make data reduction dynamic by using the customized data reduction API. Note that the objects and properties that manage this have to be set exactly as the documentation otherwise Power BI will not apply this as you expect.

Regards,

Daniel

[DmytroKurhan]

Hi @dm-p . Thanks so much for the info! I'll try to implement everything according to the documentation ( right now “window” instead of “top” doesn't work for my “matrix”, the data from PowerBI just doesn't load, but I think I just need to debug)

[lbendlin]

Do not create anything that results in a horizontal scrollbar. Users strongly dislike horizontal scrolling.

If you need to display 200 columns, use Excel.

[DmytroKurhan]

Thanks for the advice! I agree that it's best to avoid scrolling, but on this project users are used to and expect this behavior