Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Matrix Theme JSON "stepped": false moves grand total row to the top

When using a custom theme, if I try and set the stepped setting to false on a matrix, the total appears at the top of the matrix. Setting the stepped setting manual in Power BI desktop does not do this.

 

"rowHeaders": [
	{
	"outline": "none",
        "fontColor": {
            "solid": {
                "color": "#000000"
            }
        },
        "backColor": {
            "solid": {
                "color": "#FFFFFF"
            }
        },
	"stepped": false
	}
],

 

 

View before it is set to false (set manually in Power BI desktop):screen1.png

 

View after it is set to false:

screen2.png

 

 

Details taken from about section:

 

Feedback Type:
Frown (Error)

Timestamp:
2019-04-24T09:50:45.1575087Z

Local Time:
2019-04-24T10:50:45.1575087+01:00

Session ID:
295a250c-b33b-4d54-9f48-cde51f895432

Release:
March 2019

Product Version:
2.67.5404.581 (19.03) (x64)

OS Version:
Microsoft Windows NT 10.0.16299.0 (x64 en-US)

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

Peak Virtual Memory:
34.1 GB

Private Memory:
342 MB

Peak Working Set:
512 MB

IE Version:
11.1087.16299.0

User ID:
e2148bc3-49f5-40ff-b784-878234fa575c

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

Telemetry Enabled:
True

AS Live Connection:
True

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

Enabled Preview Features:
PBI_keyDrivers

Disabled Preview Features:
PBI_shapeMapVisualEnabled
MIntellisense
PBI_SpanishLinguisticsEnabled
PBI_PdfImport
PBI_ColumnProfiling
PBI_PythonSupportEnabled
PBI_showIncrementalRefreshPolicy
PBI_showManageAggregations
PBI_FuzzyMatching
PBI_improvedFilterExperience
PBI_qnaLiveConnect

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:


section Section1;

 

Status: Accepted
Comments
v-yulgu-msft
Employee

Hi @Anonymous ,

 

I have reported this problem internally, CRI:116940958 . Would update here once I get any response.

 

Best regards,

Yuliana Gu

v-yulgu-msft
Employee

Hi @Anonymous ,

 

It is a bug confirmed by PG, will update with ETA whenever available. By now, please set the property manually as a workaround.

 

Best regards,

Yuliana Gu

v-yulgu-msft
Employee
Status changed to: Accepted
 
Anonymous
Not applicable

Thank you for following this up. Just out of interest, what is PG?

v-yulgu-msft
Employee

PG means the relative product team.

v-yuta-msft
Community Support

@v-yulgu-msft ,

 

Current this issue has no ETA, the workaround is to set the property manually for now as a workaround.

 

Regards,

Jimmy Tao

Anonymous
Not applicable

Hi Team,

 

In the latest versions of PowerBI, I am still facing this issue (Grand total row moving to the top after setting stepped = 'false' in json file.

 

I am curious if there any update/ ETA for this bug. @v-yulgu-msft  

 

Regards,

Guna