Icon in conditional formatting comparing values in different table

[primolee]

I saw another post regarding similar question, but it is not exactly what I am looking for so here I am.

I want to show icon in VTR column, and the color depends on Est. VTR column.

In advance control, I can only select sum, average, min, max, etc. but I want to compare with Est. VTR on the same row.  Sum seems to be the total sum so it is not correct.

Is there a way of achieving so?  Thank you so much for your time and help.

Best regards,

David

[Anonymous · Accepted solution]

Hi @primolee,

AFAIK, current condition formation only supports to analytics aggregated table column, it does not support analyst detail values even if you use text fields. (power bi will summarize text value as first/last/count modes)

I'd like to suggest you add more category fields to your visual, then you can write a measure to extract specific value to compare with other fields and use in conditional formatting feature.

Regards,

Xiaoxin Sheng

[Mariusz]

Hi @primolee 

You need to replicate the aggregation you use in your table.

So if you use Column Est. Vtr in your table and you have applied SUM( ) as aggregation you need to do the same in Conditional Formatting.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.