Since it is not possible to have dynamic legends for combo chart as there is no "Fx" in the measures.
As an alternative I have taken separate text objects showing the "Top Portfolios" i.e 3 separate text boxes for top 3 and bottom 3 for which I will assign same colors as used in combo chart measures(conditional colors)
How do I make my condition color expression in combo chart work here.
I doubled tried to download 3.2 SR version but i could get version 3.1 SR6 only.
As a result I cannot find the below color option in existing 3.1 version. Could you share the link ?
Its that these legends/ Measure names have be dynamic so it could be that if supposedly now the top portfolio is "ABC" next time as data volume increases it could be that top portfolio (on the basis of profit) may be "XYZ" . But using this approach the name is not dynamic it will display always "ABC" as we have hardcoded in the master name area of measures.
In that case what could be done as there is no "fx" capabilities (making it dynamic) in the labels/name for measures to make it dynamic(means they will also have to be dynamic).
An alternative to this is :
1. I would continue to use 6 separate text boxes which is dynamic i.e it will show"XYZ" if it is top portfolio .
2. will hide the legends for the chart in this case our text box would serve the purpose of legends-- ( we cant show chart legends as the names have to be dynamic but we have hardcoded it in master items name.
3. Keeping the color as static both in text box and chart for the (top/ bottom 3 portfolios)