Formatting the customized color scale of a barchart

[fvarlet]

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?

[Michael_Tarallo]

@Patrik_Lundblad - thoughts?

[Patrik_Lundblad]

There isn't any method that I can think. Thanks for highlighting this!

Regards,

Patrik.