We are using a theme to ensure all of our reports look and act the same. In our latest theme file we are turning off Matrix row and column subtotals. This works as expected when the report is rendered in Power BI service. However when the user exports the matrix to excel row and column subtotals are exported.
We need to have this work through a theme as our reprots allow personalization. A user can change visuals from tables to matrix very easily. We want to control how matrix are presented on screen and exported. A theme file is the best solution for this if we continue to allow users to personalize visuals.
Below is the the theme file settings for the matrix visual.
"pivotTable": {
"*": {
"grid": [
{
"fontFamily": "Avenir Black",
"textSize": 10
}
],
"rowHeaders": [
{
"fontFamily": "Avenir Black",
"fontSize": 10,
"stepped": false,
"showExpandCollapseButtons": false
}
],
"subTotals": [
{
"rowSubtotals": false,
"columnSubtotals": false,
"fontColor": { "solid": { "color": "#FB0303" } },
"fontFamily": "Avenir Black",
"fontSize": 10,
"applyToHeaders": true,
"rowSubtotalsPosition": "Bottom",
"perRowLevel": false,
"perColumnLevel": false
}
]
}
on:
URL is not filtering on field parameter
on:
URGENT!! Paginated Report not loading on Mozilla F...
on:
In desktop, 'Recent Sources' is not retaining new ...
Could not reproduce it in my side as far as my test. When export data from matrix to excel, it shows the same result as it in Power BI Service.
Have you used 'data with current layout' feature to export data from matrix in Power BI Service?
You can consider providing more details about this issue or a sample file without any sentive information which could reproduce it better.
Best Regards,
Community Support Team _ Yingjie Li