Conditional Formatting by Row in Table Visualization

[Cyndiloo_92]

Hello!

I am stuck and trying to figure out a work around to do conditional formatting by row when each row has different criteria…. For example...

I would like to be able to insert a column indicating a symbol or be able to highlight each rows's percent bad off of that rows benchmarks (Good, OK, Bad)

I know this can be done in excel but I can not figure out a way to duplicate it in a power bi visual.

Thanks!

Name	Percent	Good	OK	Bad
Larry	96%	95%	90%	85%
Bob	87%	93%	85%	80%
Karen	92%	98%	92%	86%

[Padycosmos]

Hope this helps

[v-yueyunzh-msft]

Hi, @Cyndiloo_92 

According to your description, you want to add a column to show a symbol to show differnt index.

Here are the steps you can refer to :
(1)This is my test data:

(2)If we need to add a column wo can add the another measure (we can create again with other name) again,like this and we click "Icons" in "Conditional formatting"

Then we can configure it by yourself:

(3)Then we can get this:

For more information, you can refer to :
Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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

[Cyndiloo_92]

Each row has a percent and each percent will need to be based off of 3 different benchmarks. I am trying to figure out how to provide conditional formatting by row wheneach row has different benchmarks.

[v-yueyunzh-msft]

Hi , @Cyndiloo_92 

Thanks for your quick response and sorry for delay response due to my my holiday for several days.

I'm not fuuly understand the "Each row has a percent and each percent will need to be based off of 3 different benchmarks.", If you have 3  different benchmarks , we can try to use SWITCH() function to write your benchmarks  , you can return the corresponding value and then use the Conditional Formatting features.

If this method can not hep you , can you share the sample data and the end result you want to need as a table format so that we can help you better!

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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

[vicky_]

You can create a new measure for your specific formatting conditions. You can then use that measure in the table and use conditional formatting on the new measure. 

[Cyndiloo_92]

How Do I create a measure? Each row has a percent and each percent will need to be based off of 3 different benchmarks.

[Padycosmos]

Hope this video helps:

https://www.youtube.com/watch?v=7veYU1EeO6w