Buttons

Hi Anonymous,

Instead of buttons you could go for Chiclet slicer that is available in marketplace.
After importing the custom visual Chiclet Slicer, you need to create a table using the Enter Data option like below,

Drag the VS column to the Category Field of Chiclet Slicer. You will see something like the below image. Go to the visualisation Format option and under General Select Multiple select as OFF and Force Selection as ON.

Now you need to create 3 measures as below: (replace your column names accordingly)

SUMGP = SUM(Products[GP])

SUMOP = SUM(Products[OP])

VS_GP_OP = SWITCH(SELECTEDVALUE(VS[VS]),"vs GP",[SUMGP],"vs OP",[SUMOP])

Then modify your chart by replacing the GP and OP fields with the measure VS_GP_OP. 

Now on clicking "vs GP" you will see only two bars one for Turnover and other for GP and similary for "vs OP".

Hope this helps!!

Thanks,

Ani