Conditional Formatting in Power BI--Difference between Format by Rule and Format By Field?

[sonisick]

When would I use Rule and when would I use field?  Does it matter if it is a Measure?

[mangaus1111 · Accepted solution]

Hi @sonisick ,

I suggest you to read this article

https://www.myonlinetraininghub.com/conditional-formatting-in-power-bi-tables-and-matrices

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mangaus1111 · Accepted solution]

In short,

- if you have created a measure for the conditional formatting, then you have to select Field Value as Format Style and choose your measure;

- if you don´t have any measure for the conditional formatting, then you have to select Rules as Format Style, choose the column you want to format and settting some rules using the field parameters

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mangaus1111 · Accepted solution]

Hi @sonisick ,

I suggest you to read this article

https://www.myonlinetraininghub.com/conditional-formatting-in-power-bi-tables-and-matrices

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sonisick]

Great Article. Gave me a simple measure to modify for foreground color. This let me use the field option.