Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a combo chart.
Height of line is based o following condition:
if('$(vmeasure)'='1',[ASP per Kg],if('$(vmeasure)'='2',[Gross Margin %]*100,if('$(vmeasure)'='3',[GP per MT],'-')))
Note: vmeasure is a master variable.
Question: I want the data points format to change based on the vmeasure value.
So if vmeasure = 1 (ASP per KG), I want number format to display upto 2 decimals-1000.00
if vmeasure = 2 (Gross Margin %), I want number format to display in percentage- %
So if vmeasure = 3 (GP per MT), I want number format to display with no decimals-1000
Change the Number format to Measure expression and try to set the format inside your Master Measures: