Format Issue in line chart while using 2 different Variable button functionality
I have a line chart which is associated to two different variable buttons. I have used "two pick" statements to change the measure values of the line.
The above figure shows Year wise Attrition in Percentage and Number respectively.
Ex: We need 17.43(two decimal points) values to be shown when we select attrition in percentage.
1042(Without decimal points) to be shown when we select attrition in numbers.
Note: We need to implement this in a single chart.
We have tried to write a set expression so when we click on attrition in numbers, the Number format(num(Measure, '##0')) is written without any decimal points and when we select attrition in percentage, the number format(num(Measure,'##0.00')). But still we are unsuccessful in achieving the result.