Forum Discussion
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 "Group %"
Thank you in advance!
26 Replies
- amitchandak
Super User
jonnyA , Create a color measure and use that in conditional formatting using filed value option
Switch(True(),
[Provider %]> [Group %] *1.1 , "Green" ,
[Provider %]< [Group %] *.9 , "Red" ,
"Blue")
How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
jonnyAHow do i fix this measure witht the data i have? I couldnt get the formula you sent me to work.- aj1973
Community Champion
[Provider %] is not a measure in your model you need to create it
- jonnyA
When I try this formula all the data that was in the matrix goes away when adding the formula you said to try.
Color 3 = Switch(True(),[Provider %]> [Group Average (Ignore Degree)] *1.1 , "Green" ,[Provider %]< [Group Average (Ignore Degree)] *.9 , "Red" ,"Blue")
- 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
- jonnyA
But the Group % is not the same for all CPT codes. See what I mean? See screenshot ...
