merged
1 Topic
Conditional Formatting in concatenated text
Hey there, looks like I need your help again. These forums are something else, never failed me before. 1. What do we have? There are gates, an there is thing called "readiness". It reflects whether "we" ready to move to the next gate or not. They have their own thresholds. The visual itself are table visual and the columns here are measures based on table columns: Why not just pull column to table visual? Sometimes, there are 2, 3 gates that should be reached at the same time. And they have merged readiness via "concatenation". 2. WHAT I WANT: It is easy to conditionally format when there are but one value present (formatting based on a measure though): But how do I format them when they are merged like this? Keeping in mind that every gate has its own min and max thresholds. Conditional formatting measure example: Conditional Formatting: A = VAR MAX_a_condition = MAXX ( FILTER ( 'Readiness Table', 'Readiness Table'[Gate] = "Start A" ), 'Readiness Table'[max_theshold] ) VAR MIN_a_condition = MAXX ( FILTER ( 'Readiness Table', 'Readiness Table'[Gate] = "Start A" ), 'Readiness Table'[min_threshold] ) RETURN SWITCH ( TRUE (), OR( ISBLANK([A Readiness]), [A Readiness] = "Not Applicable"), BLANK(), [A Readiness] < MIN_alpha_condition , "FlagLow", [A Readiness] > MAX_alpha_condition , "FlagHigh", "FlagMedium" ) It is okay if there is no way of doing it... But there might be some?Solved3.3KViews0likes6Comments