search

Profitbase / PowerBI-visuals-FinancialReportingMatrix

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

Total Displaying in double #125

Open AzizBoumiza opened 4 years ago

AzizBoumiza commented 4 years ago

Hello Tor once more,

I would like to share with you my experience with the (subtotal Column ). I tried to activate the subtotal but i got this problem Details below: image

But when i Add a time dimension in the Columns (which i found out in one of your responds) It works but displays the Total in Double x2: image

Here is the the Error detail for the first case: image

Error code below:

Feedback Type: Frown (Error)

Timestamp: 2020-07-02T09:25:21.4407960Z

Local Time: 2020-07-02T10:25:21.4407960+01:00

Session ID: c39ced40-149e-4332-b224-2193xxxxxxxa4e

Release: May 2020

Product Version: 2.81.5831.1181 (20.05) (x64)

Error Message: The Limit 'L2' defines a limit that spans multiple groups. Limit 'L1' also spans multiple groups and is defined on the same DataShape. Only one such Limit is allowed on a DataShape.

OS Version: Microsoft Windows NT 10.0.16299.0 (x64 fr-FR)

CLR Version: 4.7 or later [Release Number = 461814]

Peak Virtual Memory: 35.1 GB

Private Memory: 536 MB

Peak Working Set: 721 MB

IE Version: 11.1932.16299.0

User ID: 294392f4-db80-4334-abbf-377xxxxxxf76

Workbook Package Info: 1* - fr-FR, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled: True

AS Live Connection: True

Performance Trace Logs: C:\Users\mboumiza\AppData\Local\Microsoft\Power BI Desktop SSRS\PerformanceTraces.zip

Enabled Preview Features: PBI_NewWebTableInference PBI_hierarchicalSlicerCreation

Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_inlineExplore PBI_realTimeRefresh PBI_showMinervaRibbon PBI_showMinervaViewNavigator PBI_v3ModelsPreview PBI_relativeTimeSlicer PBI_dataSearchCuration

Enabled DirectQuery Options: TreatHanaAsRelationalSource

Cloud: GlobalCloud

DPI Scale: 100%

Supported Services: Power BI Report Server, Power BI

Formulas:

section Section1;

I really hope you can help me with that, thanks in advance !

toresenneseth commented 4 years ago

Using SSAS? We'll probably need to contact Microsoft as well to figure this out, because none of those error messages are generated by us (and it only fails when using SSAS as far as I know).

The Limit 'L2' defines a limit that spans multiple groups. Limit 'L1' also spans multiple groups and is defined on the same DataShape. Only one such Limit is allowed on a DataShape.

In version 2, we switched to using a different API version in Power BI, and this might be causing the errors you are seeing.

AzizBoumiza commented 4 years ago

Hey Tor,

Any updates concerning this problem ? Could we have an option to hide a column as a Workaround solution?

Thank you :)

toresenneseth commented 4 years ago

We're still waiting for a response from Microsoft on this one. Regarding hiding columns, we do support that in version 3, but only at the lowest level (not grouping columns).