Forum Discussion

mussol_'s avatar
mussol_
Advocate II
7 years ago
Solved

JSON parameter for pivotTable --> "stylePreset"

Hi all,

I am trying to build a corporative theme in JSON file.

I need to set the style preset for the matrix visual as "Alternating rows", so I tried possible combinations on the following instruction:

 

"pivotTable": {
"*": {
"stylePreset":[{
"name":"Alternating rows"
}],

 

But it turns to "Default" on PBI desktop.

If the style preset is defined with only one word (for example: None, Minimal, Condensed, etc.) there is no problem and it works.

Which is the parameter I should use?

 

Many thanks in advance.

 

Josep.

Need Help
  • nickyvv's avatar
    nickyvv
    6 years ago

    Hi mussol_,

    Ah, I tried some variations and came up with the correct one. The complete JSON for a Matrix is:

    "pivotTable": {
	"*": {
		"stylePreset": [
			{
				"name": "AlternatingRows"
			}
		]
	}
},

2 Replies

  • nickyvv's avatar
    nickyvv
    Most Valuable Professional
    6 years ago
    Did you happen to figure this one out? I'm also struggling on this 🙂
    • nickyvv's avatar
      nickyvv
      Most Valuable Professional
      6 years ago

      Hi mussol_,

      Ah, I tried some variations and came up with the correct one. The complete JSON for a Matrix is:

      "pivotTable": {
	"*": {
		"stylePreset": [
			{
				"name": "AlternatingRows"
			}
		]
	}
},