Forum Discussion
Dynamic target line based on slicer selection
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.
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 🙂
1 Reply
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 🙂