Custom Data bars

Hi _Abhilash ,

You can try to create a measure with your scenarios and give it a value. For example,

CondiIcons = 

VAR _Actual = YOUR_ACTUAL_SUM_MEASURE
VAR _Avg = YOUR_AVG_MEASURE
VAR _Indicator = MAX(YOUR_TABLE[Indicator]) 

RETURN

SWITCH( TRUE(),
_Indicator = "A" && _Actual > _Avg, 1,      // Green Up
_Indicator = "B" && _Actual < _Avg, 2,      // Green Down
_Indicator = "C" && _Actual > _Avg, 1,      // Green Up
_Indicator = "D" && _Actual > _Avg, 3,      // Red Up
_Indicator = "E" && _Actual < _Avg, 4       // Red Down
)

Then in the conditional format settings, turn on Icons and have the setting to this:

Let me know if this is what you're looking for.

Hi _Abhilash 

You can try this, create the 2 measures below,

Measure = IF(MIN('Table'[Actual])>MIN('Table'[Avg Actual]), UNICHAR(129093),UNICHAR(129095))

Color = IF(MIN('Table'[Indicator]) in {"A","B","C"}, "green","red")

result

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.