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

[schanna]

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.

[amitchandak · Accepted solution]

@schanna , Use field parameter release in May 2022, that is a better option

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf