Forum Discussion

jonnyA's avatar
jonnyA
Icon for Responsive Resident rankResponsive Resident
5 years ago

Using 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...
Need Help
jonnyA's avatar
jonnyA
Icon for Responsive Resident rankResponsive Resident
5 years ago

What exactly do you want me to show you?

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

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

 

Can you share your file? in private if you want

  • jonnyA's avatar
    jonnyA
    Icon for Responsive Resident rankResponsive Resident
    5 years ago

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

     

     

    • aj1973's avatar
      aj1973
      Icon for Community Champion rankCommunity Champion
      5 years ago

      what is the measure behind this column?

      use one of these measure so I can see the outcome

       

      • jonnyA's avatar
        jonnyA
        Icon for Responsive Resident rankResponsive Resident
        5 years ago
        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])