Forum Discussion

F_Reh's avatar
F_Reh
Icon for Post Patron rankPost Patron
2 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 ...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
2 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.