Display percentage and non percentage values in a funnel visual?

[owenian5]

How can I display both percentage & non-percentage values together in a funnel visual?

Avail Prod Time = 7071

Operating Time = 6714

Actual OPI = 65%

Actual Asset Utilization = 60%

FYI, the 'Actual OPI' & 'Actual Asset Utilization' have been formatted as Percentage. 

          'Avail Prod Time' & 'Operating Time' have been formatted as Whole number. 

When all display together on funnel visual, 'Actual OPI' & 'Actual Asset Utilization' are displayed in incorrect format, not percentage. (E.g. 0.65 round up to 1, instead of 65%)

[amitchandak]

@owenian5 , If you are creating a combine text then format it

[Actual OPI] & format([Actual Asset Utilization], "percent")

[owenian5]

Hi amitchandak,

What I need is to display all parameters in the funnel visual, with the correct format.

What I WANT to obtain in funnel visual

Avail Prod Time = 7071                     [No % symbol]

Operating Time = 6714                    [No % symbol]

Actual OPI = 65%                              [with % symbol]

Actual Asset Utilization = 60%          [with % symbol]

What I DO NOT WANT to obtain in funnel visual

Avail Prod Time = 7071

Operating Time = 6714

Actual OPI = 1                           [Currently in the above picture, it is showing 0.65 ≈ 1]

Actual Asset Utilization = 1      [Currently in the above picture, it is showing 0.60 ≈1]