Forum Discussion
Conditional formatting based on another cell
- 8 years ago
Hi hello789567
such art of formatting is with second transparent table and manipulating with font and background color possible.
One of table (top level) must be have table style as "None".
Look on simple example below:I hope its help. I left extra uneven matrix edges, that you can better see this trick.
And of course you must prepare a values of means you need (as separate measures or calculated columns).
Best regs
- 8 years ago
Thank you for your response! Its looking like controllable formatting is a feature that's just not in Power Bi. I had to resort to inserting "Text Boxes" with no text and giving it a transparent background. Considering how much conditional formatting is helpful to reporting you would think it would be better.
Hi hello789567
such art of formatting is with second transparent table and manipulating with font and background color possible.
One of table (top level) must be have table style as "None".
Look on simple example below:
I hope its help. I left extra uneven matrix edges, that you can better see this trick.
And of course you must prepare a values of means you need (as separate measures or calculated columns).
Best regs
- hello7895678 years agoAdvocate I
Thank you for your response! Its looking like controllable formatting is a feature that's just not in Power Bi. I had to resort to inserting "Text Boxes" with no text and giving it a transparent background. Considering how much conditional formatting is helpful to reporting you would think it would be better.
- McCow8 years agoResolver III
hello789567 wrote:Thank you for your response!
with pleasure!
perhaps Microsoft makes this feature better and comfortable in the nearest future
- v-huizhn-msft8 years agoMicrosoft Employee
Hi hello789567,
You can create an idea here, and please mark the right/useful reply as answer, so that we can close the thread and more people will benefit from here.
Thanks,
Angelia
- Acoronado18 years agoNew Member
Hello, the conditional format of the field is not working on the web, there is some way to be able to report this error of the platform.
I appreciate if you can help me, thanks.
- McCow8 years agoResolver III