"No Color" option missing in formatting

An example of how it's actually necessary to be able to select "No Color":

I have Row Grand Totals selected to be Grey, however my Column on the Right has a Specific Column color of White.  But if you turn off apply to Totals so that it goes Grey, then I lose the ability to Center the Total value.  I either need the ability to Center Row Grand Totals or apply No Color to the Specific Column.

The only reason my column on the Left still works is because I never applied a Color to it, so it's still holding on to "No Color" thankfully.

This is ridiculous isn't it? Jesus Christ, this is a Microsoft product. More than 2 years that they know about this bug and no solution yet. 

I have not found a direct solution.

But the workaround is to remove that column from your chart/matrix and then add it again. It seems to reset the specific column settings.

Hope this helps

Hi Cassidy,

In case it is still relevant, you can try to reload a theme in which the color setting for this specific item in the visual is not set.

If you have a specific theme you need to use, try to edit it: 

• save your current theme as a .json-file
• open the theme-file and search for your visual name in the code
• delete the color from the visual settings (this makes it 'no color')
• save your new theme-file and reload it via 'browse for themes'

For example, write something like this: 

"pivotTable": { "*": {
      //...
     "subTotals": [{
          "rowSubtotals": false,
          "columnSubtotals": true,
          "fontColor": {"solid":{"color";"#846EAF"}},
          }]

Instead of this: 

"pivotTable": { "*": {
      //...
     "subTotals": [{
          "rowSubtotals": false,
          "columnSubtotals": true,
          "fontColor": {"solid":{"color";"#846EAF"}},
          "backColor": {"solid":{"color";"#E6E6E6"}}
          }]

I got a workaround for this, just select white color and make transparency to 100%. It is same as no fill