Forum Discussion

epang's avatar
epang
Advocate I
3 years ago

How to do conditional formatting

I have list of survey data for multiple organisations.    THey have provided minium target, long term target and actual value.    Eg company A Team A has a question about Staff satisfaction.  min...
Need Help
SamInogic's avatar
SamInogic
Super User
3 years ago

Hi epang ,

 

We have considered that the data table include below sample data,

You can create a column with DAX to define colour based on the conditions you mentioned for Actual value,


Color for Result = IF('TargetData'[actual ] < 'TargetData'[Minimum Target], "Red", IF('TargetData'[actual ] >= 'TargetData'[Minimum Target] && 'TargetData'[actual ] < 'TargetData'[long term target], "Yellow", IF('TargetData'[actual ] >= 'TargetData'[long term target],"Green")))

Based on this colour you can show traffic signal icons in column of table, for this add the “Color if Result” column and apply conditional formatting.

 

Please refer to the below screenshot for the same.

 

This will result as follows,

 

Thanks!

 

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at [email protected]

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

  • epang's avatar
    epang
    Advocate I
    3 years ago

    here is the dax measure I have created. 

     

    Color = if('11 Staff Satisfaction'[Value]>= '11 Staff Satisfaction'[3 Satisfaction Targets.Long Term Target], "Green", if('11 Staff Satisfaction'[Value] >= '11 Staff Satisfaction'[3 Satisfaction Targets.Minimum Target],"Orange", if('11 Staff Satisfaction'[Value] <'11 Staff Satisfaction'[3 Satisfaction Targets.Minimum Target], "Red")))
     
    However, I cannot apply this to callout value coloring scheme. Any clue?