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
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

Use this please and show me

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

 

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

The data doesnt seem to like that formula ...

 

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

    Something is not correct!!

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

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

    Yes, give me a few minutes!  Thank you

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

    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's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    5 years ago

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

    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?