Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic constant line based on different values with slicer

Hello Experts,

 

Tried to find many ways but nothing helped yet, would need help on dynamic contatnt line based on values of a column and a slicer selected.

Snap attached, the requirement is , 


 Slicer/Filter - Domain Column
Stack Chart of - Metric column, Provided we already have a stack chart prepared, just need to add the dynamic constant line for showing the targets
Contant line - Target 2021 column

 

For example, If i select Domain= A, for Test Auomation stcack chart the Target line should show as 23 and for Car Automation stcack chart the Target line should show as 45

Thanks in advance

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Create a measure and use that in Analytic pane in visualization -> contact line -> Fx and choose measures

    Test Automation = calculate(sum(Table[Value]), filter(Table, Table[Metric]=" Test Automation"))

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , Create a measure and use that in Analytic pane in visualization -> contact line -> Fx and choose measures

    Test Automation = calculate(sum(Table[Value]), filter(Table, Table[Metric]=" Test Automation"))

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks amitchandak , with some small changes it's working now.