Show absolute values and percentage values as toggle in the chart

[MadhuriReddy]

Hello Everyone,

I have to create toggle button to the absolute values and percentage values in the all  sheets of dashboard. Can anyone help to create toggle button and  reflect the changes in the chart 

Thanks in advance

Madhuri

[MadhuriReddy · Accepted solution]

I found solution for toggle on Percentage and absolute

I created a Variable and used the variable in the expression

if('$(vPercent_Absolute)'= 'Absolute',  

sum(sales),

Sum(total <[Month Year]> sales))