Non Functioning Slicer Options : Dynamically Changing X-Axis of Vertical Bar chart

Hello Members,

Objective : To dynamically change metrics in the X-axis of vertical bar chart while keep y- axis constant.

Problem : Two metrics selected in the slicer are not rendering in the bar chart namely. That is viz not getting generated in bar chart:

                 (a) "CYTD vs PYTD %"

                    (b) "CYMTD vs PYMTD %"

Implementation: 

1) Table created with a field which contains names of different metrics to show in bar chart.

2) Measure created with switch function to tie the metric names with appropriate metric dax calculations is as under:

3) All the metrics listed above are absolute (in millions) expect for the two metric listed in problem which are relative (in percentage).

4) Dax Code for the issue metrics are as under (relative data type in percentage):

   (a) "CYTD vs PYTD %"  ---- IFERROR( ( [NIS CYTD]-[NIS PYTD] ) / abs( [NIS PYTD] ), 0 )

5) We tried making the two listed above problem metric data type into decimal but the problem persisit.

    (b) CYMTD vs PYMTD % ------  IFERROR( ( [NIS MTD]-[NIS PYMTD] )/abs( [NIS PYMTD] ), 0 )

Request members to provide support in solving this issue.