Hi all,
I've created a barchart using a measure for its colors.
It works well.
I would like to display units too, in the color legend and in the measure (displayed when the mouse is over a bar).
I've tried using Num(measure), Money(measure) (as the unit is a monetary unit), and even Dual(), but these functions have no effect.
For example, with Dual():
=Dual(
Avg(
Aggr(Sum({<OLC_PipelineStatus={"Closed Won"}
, OLC_Status={'C03_Closed'}
, TotalVsWeighted={'Total amount'}
>} OLC_AmountPerProduct), OLC_OpportunityNumber, OLC_DateSnapshot)
)
&' k€'
,
Avg(
Aggr(Sum({<OLC_PipelineStatus={"Closed Won"}
, OLC_Status={'C03_Closed'}
, TotalVsWeighted={'Total amount'}
>} OLC_AmountPerProduct), OLC_OpportunityNumber, OLC_DateSnapshot)
)
)The unit never appears.
Is there a way to display units with color scales?
