https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-target-line-based-on-slicer-selection/m-p/2851089#M91388 <P>Hi everyone ,</P><P>&nbsp;</P><P>I am trying to add a target line to my barchart however i am struggling to find a way to make the target line dynamic based on the slicer selection</P><P>&nbsp;</P><P>As an example i want the target line to be 300 for Slicer selection A, 200 for Slicer selection B etc.</P><P>&nbsp;</P><P>Is that possible ?</P><P>&nbsp;</P><P>Thank you.</P> Wed, 19 Oct 2022 10:35:29 GMT georgec96 2022-10-19T10:35:29Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-target-line-based-on-slicer-selection/m-p/2851089#M91388 <P>Hi everyone ,</P><P>&nbsp;</P><P>I am trying to add a target line to my barchart however i am struggling to find a way to make the target line dynamic based on the slicer selection</P><P>&nbsp;</P><P>As an example i want the target line to be 300 for Slicer selection A, 200 for Slicer selection B etc.</P><P>&nbsp;</P><P>Is that possible ?</P><P>&nbsp;</P><P>Thank you.</P> Wed, 19 Oct 2022 10:35:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-target-line-based-on-slicer-selection/m-p/2851089#M91388 georgec96 2022-10-19T10:35:29Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-target-line-based-on-slicer-selection/m-p/2852571#M91522 <P>Surely it's possible. Please find a file attached... By the way, instead of hard-coding the values of the line in the measure itself, you could actually have a mapping table. I think this would be more flexible but I was lazy <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Thu, 20 Oct 2022 04:58:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-target-line-based-on-slicer-selection/m-p/2852571#M91522 daXtreme 2022-10-20T04:58:43Z