Using Conditional Formatting to show 10% above and 10% below Group%

[jonnyA]

Using Conditional Formatting how could I highlight the "Provider %" which is 10% above the "Group %"

Using Conditional Formatting how could I highlight the "Provider %" which is 10% below the "Group %"

Thank you in advance!

[jonnyA]

But the Group % is not the same for all CPT codes.  See what I mean?  See screenshot ...

[aj1973]

Yes I know what you mean, you want it to be dynamic...I just wanted to test the measure color how it works out.

Can you show me please?

[jonnyA]

What exactly do you want me to show you?

[aj1973]

the column Color 2 when you add it to the visual.

Can you share your file? in private if you want

[jonnyA]

I'm not sure what you mean?  Color 2 is added to the visual.

[aj1973]

what is the measure behind this column?

use one of these measure so I can see the outcome

[jonnyA]

This is where I am at right now witht the color 2 measure you gave me.

[aj1973]

Use this please and show me

Color 2 = IF ( [Provider %] > 0.01837 , "Green" , IF ( [Provider %] < 0.01837 , "Red"))

[jonnyA]

The data doesnt seem to like that formula ...

[aj1973]

Something is not correct!!

Can you make a Sample of your file and share it with us?

[jonnyA]

@aj1973 ,

Hello!

Its been a little while since I lasted visited this report.  i am still stuck on trying to get to work.

I think one of the problems I am having is that in your file your "Group %" has the E.  My "Group %" is a calculated measure.  

Group % = Sumx(Values('Test File_Charge_Dataset'[Provider_Degree]),'Test File_Charge_Dataset'[Group Average (Ignore Degree)]).

Group Average (Ignore Degree) = IF (

ISFILTERED (Test File_Charge_Dataset[Provider_Degree]), CALCULATE([Group Average], REMOVEFILTERS(Test File_Charge_Dataset[Provider_Degree])), [Group Average])

In my matrix "Group %" is shown as "Percent of Grand Total"

[aj1973]

Hi @jonnyA 

I don't get your point!!! In this thread we were talking about Colors and it seems like you are talking about something completly different!

Maybe you should open a new thread and yuo should provide a sample of your file.

[jonnyA]

@aj1973 ,

Sorry for the confusion.  I am still trying to Highlight rows where the Provider % is 10% above or below the Group % I have a sample that you sent me last month, but I cannot attach it to the Power BI community.  Could you provide me your email and I'll send you the test file?

[aj1973]

jerbi73@gmail.com

[jonnyA]

Yes, give me a few minutes!  Thank you

[jonnyA]

Color 2 = IF ( [Provider %] > 1.1 * [Group Average (Ignore Degree)] , "Green" , IF ( [Provider %] < 1.1 * [Group Average (Ignore Degree)] , "Red"))

Provider % = COUNT( 'Table_Charge_Dataset'[CPT_Code])

Group Average (Ignore Degree) = IF (

ISFILTERED (Table_Charge_Dataset[Provider_Degree]), CALCULATE([Group Average], REMOVEFILTERS(Table_Charge_Dataset[Provider_Degree])), [Group Average])

[jonnyA]

Your previous comment is 3 formula's correct?  I tried them, but cannot get to work.

[jonnyA]

I created the following formulas ...

Provider % = COUNT( 'MEDONE_Charge_Dataset'[CPT_Code])

Color 2 = IF ( [Provider %] > 1.1 * [Group Average (Ignore Degree)] , "Green" , IF ( [Provider %] < 1.1 * [Group Average (Ignore Degree)] , "Red"))

But everything came back "Red", but i dont know why?

[aj1973]

I have a doubt on the Group % measure (the unit)!!

Since Group % is constant and equal 0.0167 can you replace in this formula

Color 2 = IF ( [Provider %] > 1.1 * 0.0167 , "Green" , IF ( [Provider %] < 1.1 * 0.0167 , "Red")) or

Color 2 = IF ( [Provider %] > 0.01837 , "Green" , IF ( [Provider %] < 0.01837 , "Red"))

let me know

[aj1973]

Hi @jonnyA 

You need to add a measure for color like

Color = IF ( Provider % > 1.1 * Group % , "Green" , IF ( Provider % < 1.1 * Group % , "Red"))

then use this measure to apply into

here is an example