How to flag the progress bar red if exceed 100% in matrix table

[rachelbi]

Hi there, I am making a matrix table and would like to show the bar into red if exceed 100% (i.e. means out of the project tracking), how can I work on it? Thanks very much.

[v-yiruan-msft · Accepted solution]

@ryan_mayu Thanks for your contribution on this thread.

Hi @rachelbi ,

As you can see the one in the below screenshot, the bar color can only be set to display a gradient color within a certain range of values. 

There is a workaround where you can set a conditional format for the Font color on the value field. You can refer to the following steps:

1. Create a measure as below 

Font color conditional formatting = IF([% Time Spent Progress]>1,"red")

2. Configure Conditional formatting -- Font color for the value field [% Time Spent Progress]

Best Regards

[ryan_mayu]

@rachelbi 

pls try this

pls see the attachment below

[rachelbi]

thank you @ryan_mayu . My apology for being confused, I am working on a matrix table instead of a chart. 

i would like to indicate "108%" flagged as red bar as shown below exceed the planned time frame.

[ryan_mayu]

i didn't find the settings for a bar in matrix, either. Sry about that. Let's see if anyone else can help you on that.

[rachelbi]

No worries, thanks @ryan_mayu