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!
Paginated Report Builder Treemap Issues
We've been working with Treemaps in Paginated Report Builder and encountered a challenge: How can we remove the category field name that appears in the top left corner of the visualisation? After a lot of trial and error, our team managed to hide it using the following expression in the Data Label Visibility property: =IIf(Count(Fields!PSA_Assets_AssetName_.Value)>1,true,false) Strangely, this only works with >1. If we try >0 or even >0.9, the label remains visible. We consider this more of a workaround than a proper solution — especially since, when a manufacturer only has one asset, this method hides both the manufacturer name and the count, which is not ideal for reporting clarity. Has anyone found a more robust or elegant solution to this issue? Thanks in advance! Martina Cahya Pratiwi Business Intelligence Analyst www.teamlogix.com.au
