Conditional Formatting not updating when using a Percent Slicer.

[stein97]

I have a table with a column that I am calculating a percent based on 2 other columns.

Here is the calculation:

if [MAXSCORE] <> null and [MAXSCORE] <> 0 then Number.ToText(Number.Round(([CURRENT SCORE] / [MAXSCORE]) * 100, 2), "0.00") & "%" else null

Here is the Conditional Formatting:

Issue:

When the slice is moved to .99% the Conditional Formatting no longer represents the correct coloring.

If the % is greater than 51.99 the color should be green

Here is the screenshot with the Percent Slice at 99%, the bottom 2 values which are not greater than 51.99 turn green

Any thoughts on the issue?

Thank 

[MFelix · Accepted solution]

Hi @stein97 ,

The Percente value on the condittional formatting is not used for "percentages calculations" this is for the a percentage of the data you have so the top 50% would have a certain color and the rest another color. To have this matching your metric you need to use a decimal and select the option number so you woul need to set

0.0 - 0.4899

0.499 - 0.5199

0.52 - 1

Allof this must be set has number in the conditional formatting screen.

[MFelix · Accepted solution]

Hi @stein97 ,

The Percente value on the condittional formatting is not used for "percentages calculations" this is for the a percentage of the data you have so the top 50% would have a certain color and the rest another color. To have this matching your metric you need to use a decimal and select the option number so you woul need to set

0.0 - 0.4899

0.499 - 0.5199

0.52 - 1

Allof this must be set has number in the conditional formatting screen.

[stein97]

Miguel Félix,

OK that explains the Slicer issue!

If I change the Table to a decmial instead of a percentage this will resolve my issue? Or is the Slicer always a percentage of the data in the whole table?

thanks

[MFelix · Accepted solution]

You can keep everything has a percentage except for the conditional formatting, because it uses the raw data and not the formarted one.

The percentage of data is only on the conditional formating on the other visualizations % is a format and works properly. 

[stein97]

That worked!!!

Thanks!