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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Setting "Stepped" as False in a theme file for Matrix (pivotTable) under 'RowHeaders' causes issues

Create a new theme file and add this to your JSON:

"visualStyles":
	{
		"pivotTable":
		{
			"*":
			{								
				"rowHeaders":[
				{
					"stepped":false
				}]
			}
		}
	}

 

Create a matrix and put totals on.  You will find the Totals Row will display at the top no matter what you set the position property to:

RossEdwards_0-1715916597901.png

 

Problem can be worked around by toggling on then off the 'Stepped Layout' setting.  After that, the select of position works correctly to whatever has been selected.

RossEdwards_1-1715920080260.png

 

I don't know what the toggling is required, something about the importing of the theme file breaks something.

 

Status: Needs Info

Hi @RossEdwards 

Following this paragraph you provided, I tested it, but an error was reported. Can you provide a full json file with your steps? Also, what version of PBI Desktop are you testing?

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Needs Info

Hi @RossEdwards 

Following this paragraph you provided, I tested it, but an error was reported. Can you provide a full json file with your steps? Also, what version of PBI Desktop are you testing?

 

Best Regards,
Community Support Team _ Ailsa Tao

RossEdwards
Solution Specialist

Attached is the theme file.  To create this theme file:

  • Open A blank power BI report.
  • Go to View and select any theme (i used the accesible theme)
  • Select "Save Current Theme" from the theme drop down.
  • Add the code from my original post into the exported theme.
  • You should have:
{
  "name": "CY23SU02",
  "dataColors": [
    "#118DFF",
    "#12239E",
    "#E66C37",
    "#6B007B",
    "#E645AB",
    "#4A2D75",
    "#1AAB40",
    "#10433F",
    "#3599B8",
    "#DFBFBF",
    "#4AC5BB",
    "#5F6B6D",
    "#FB8281",
    "#F4D25A",
    "#7F898A",
    "#A4DDEE",
    "#FDAB89",
    "#B687AC",
    "#28738A",
    "#A78F8F",
    "#168980",
    "#293537",
    "#BB4A4A",
    "#B59525",
    "#475052",
    "#6A9FB0",
    "#BD7150",
    "#7B4F71",
    "#1B4D5C",
    "#706060",
    "#0F5C55",
    "#1C2325"
  ],
  "foreground": "#131312",
  "background": "#FFFFFF",
  "foregroundNeutralSecondary": "#6C6966",
  "backgroundLight": "#E5E0DA",
  "foregroundNeutralTertiary": "#ABA7A2",
  "backgroundNeutral": "#C6C2BE",
  "tableAccent": "#118DFF",
  "maximum": "#4A2D75",
  "center": "#1AAB40",
  "minimum": "#E645AB",
  "bad": "#E66C37",
  "neutral": "#6B007B",
  "good": "#12239E",
  "visualStyles":
	{
		"pivotTable":
		{
			"*":
			{								
				"rowHeaders":[
				{
					"stepped":false
				}]
			}
		}
	}
}