Dynamic target line based on slicer selection

[georgec96]

Hi everyone ,

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

As an example i want the target line to be 300 for Slicer selection A, 200 for Slicer selection B etc.

Is that possible ?

Thank you.

[daXtreme · Accepted solution]

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 🙂