Forum Discussion
jonnyA
Responsive Resident
Responsive ResidentUsing Conditional Formatting to show 10% above and 10% below Group%
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 "Gr...
aj1973
Community Champion
Community Championthe column Color 2 when you add it to the visual.
Can you share your file? in private if you want
jonnyAResponsive Resident
Responsive ResidentI'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
- jonnyAColor 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
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"))