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

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?