March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
There use to be the option to select "No Color". In some cases, there is an advantage to selecting No Color vs. White.
Any one know what happened to it or how to implement No Color?
Solved! Go to Solution.
I've found that somone called this issue nearly 2 Years ago via the Idea below. Please vote for the Idea if you come across this post:
https://ideas.powerbi.com/ideas/idea/?ideaid=f4f23700-b785-eb11-8ced-281878dec3c7
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.
Right? I so sick and tired of crappy microsoft products with no support and relying on users to find and make workarounds for all the bugs and stupid ideas.
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:
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 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
I've found that somone called this issue nearly 2 Years ago via the Idea below. Please vote for the Idea if you come across this post:
https://ideas.powerbi.com/ideas/idea/?ideaid=f4f23700-b785-eb11-8ced-281878dec3c7
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
170 | |
145 | |
90 | |
67 | |
58 |