Forum Discussion

F_Reh's avatar
F_Reh
Icon for Post Patron rankPost Patron
3 years ago

Hide/Unhide (%) Target Line on Bar Chart which Toggles between % and Absolute Values

Good Afternoon,

 

I have a Bar Chart which is linked with a slicer for toggling the Y-Axis between either Percentages (%) or the Absolute Figures. Is it possible to display the (Percentage) Target line only when Percentages (%) is selected from the Slicer ? The (Percentage) Target line must disappear whenever the Absolute Figures option is selected (on obvious grounds).

 

Thanks

Need Help

1 Reply

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    3 years ago

    Hi F_Reh ,

     

    I assume you are using field parameters to make this change correct? 

     

    And the target line is a measure you are using on the line, for this just change you target line measure to something similar to this:

    Target Measure = IF( SELECTEDVALUE(FieldParameter[Order]) = 0 ,  [TargetMeasure])

     

    I assume that the Absolute figure is the first on your field parameter but if it's not you need to change the 0 to the correct number of the metric, and this will blank out the values for the target measure when you have any other value selected.