Forum Discussion
primolee
Helper V
Helper VIcon in conditional formatting comparing values in different table
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 adv...
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
Community Champion
Community ChampionHi 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.
Mariusz
If this post helps, then please consider Accepting it as the solution.