Conditional coloring by rank not applying to time-series chart
Hi everyone, my model looks like: I’m using the following measures to color visuals dynamically based on ranking: Rank (Current Axis) = VAR Result = IF ( ISINSCOPE ( fct_amortizedcosts[MeterSubCategory] ), RANKX ( ALLSELECTED ( fct_amortizedcosts[MeterSubCategory] ), CALCULATE ( [Total Amortized Cost] ), , DESC, DENSE ), IF ( ISINSCOPE ( fct_amortizedcosts[MeterCategory] ), RANKX ( ALLSELECTED ( fct_amortizedcosts[MeterCategory] ), CALCULATE ( [Total Amortized Cost] ), , DESC, DENSE ), BLANK () ) ) RETURN Result Color by Rank = VAR r = [Rank (Current Axis)] RETURN SWITCH ( TRUE(), ISBLANK ( r ) || r > 5, "#B3B3B3", r = 1, "#E81123", r = 2, "#107C10", r = 3, "#0078D4", r = 4, "#FFB900", r = 5, "#8E8CD8" ) This works perfectly in donut and bar charts, but when I try to apply the same color logic to a Line and clustered column chart (with Date on the X-axis), all columns turn gray: Has anyone managed to make field value–based coloring work on a time-series chart when the rank is calculated by category (MeterCategory) and not by the date axis? Example mode, use Problem to solve page: https://drive.google.com/file/d/14lpEWK-MQ6JMU5_15WVh8Gv22AiGvdpR/view?usp=drive_link I think that MeterCategory column does not exist in specific visual and this is why visual does not read it as ISINSCOPE function. I tried with HasONeValue but the same i think it is in visual level, not page level filter context...how to pass this ? Thanks for any suggestions!
