Custom Theme Preview for Visuals: Visual Name for Matrix?

[Anonymous]

Using the Sept 2017 PBI Desktop, with custom theme preview...

I am trying to apply a default theme for a matrix.  The visual name of "matrix" does not seem to work.

Here is an excerpt of my theme JSON file:

----------------------------------------------------

  "tableEx":{
   "*":{
    "*":[{
     "fontSize":20
    }]
   }
  }

,

  "matrix":{
   "*":{
    "*":[{
     "fontSize":20
    }]
   }
  }

,

----------------------------------------------------

The format for "tableEx" is applied.  but the format for matrix is not applied.  There is no "matrixEx" visual, I think.  Is this a known limitation?

[TomMartens · Accepted solution]

Hey,

maybe one of the mysteries of naming things ...

The name you have to use for the matrix visual is pivotTable:

"pivotTable": {
			"*": {
				"rowHeaders": [{
					"fontSize":14
				}],
				"columnHeaders": [{
					"fontSize":14
				}],
				"values": [{
					"fontSize":12
				}]
			}
		}

Regards

Tom

[LeahSQL]

How do you know that? The documentation says there is a visual called "matrix". Do you have a more complete set of documentation? I'm trying to change the font color (of anything!) and I cannot seem to do it. fontColor, color don't seem to work.

{
  "name": "test",
  "dataColors": [ "#FC9425", "#33C6BB"],
  "background": "#293537",
  "foreground": "#6B7A8F",
  "tableAccent": "#6B7A8F",
  "visualStyles": {
    "card": {
      "*": {
        "labels": [
          {
            "fontSize": 30,
            "color": "#FFFFFF"
          }
        ],
        "categoryLabels": [
          {
            "fontSize": 16
          }
        ]
      }
    }

  }
}

[TomMartens]

Hey @LeahSQL,

unfortunately I do not have a more complete set of documentation. The documentation also states that there is a visual called "pivotTable". I wanted to change the "Matrix" visual, because matrix, didn't work I tried promising visuals, and pivotTable worked - that simple.

Regards

Tom 

[Anonymous]

Thanks Tom!  If I went down the list one by one I would have found it eventually.  Thanks for the time savings and for pointing me in the right direction!

[LeahSQL]

In case anyone is wondering, you can set the font color, the syntax is like this:

  "visualStyles": {
    "*": {
      "*": {
        "*": [
          {
            "fontSize": 10,
            "fontFamily": "Segoe UI",
            "color": { "solid": { "color": "#E6E6E6" } }
          }
        ]
      }
    }
  }

There's a great tool for creating custom themes here: https://powerbi.tips/tools/report-theme-generator-v3/

Thank you to Adam Harper from PowerDAX for pointing it out!

[Anonymous]

Glad the theme generator was updated!  Thanks for the tip!

What did you refer to to figure out the syntax of  "color": { "solid": { "color": "#E6E6E6" } } ???  That's not in the reference material that was published along with the September update.

[LeahSQL]

I know! It would be really great if the documentation were more complete. I mined it out of the file produced by the theme generator.