Forum Discussion

miltenburger's avatar
miltenburger
Helper V
7 years ago
Solved

Dynamic constant line

Hi Guys,   I'm trying to figure out if there is a possibility to work with a dynamic constant line. My current visual is based on healthcare data. What I can show them right now is the running tota...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    miltenburger,

     

    I'm afraid this couldn't be achieved because the value of constant line is determined by constant value, it can't be changed by slicer. As a workaround. I would recommend you to create a measure using DAX like pattern:

     

    Measure =
SELECTEDVALUE ( table[value] )

    And then drag the measure to your chart.

     

    Regards,

    Jimmy Tao

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello marcoselias I tried the steps as following. However the constant line has no value showing. The target should be 5.2bn. Any suggestions. thank you

 
 
eeramirezo's avatar
eeramirezo
New Member
4 years ago

I found,  that is  possible to achieve that.  Using  this  steps: 

 

1.  Create a  Measure that have the desired  values,  according with  the value  of slicer.  It could be in  a form  of  if  statement.  If  selected value  is  x  then  y. 

 

2.   Add constant  line  in  Analytics  section.  In the value,  you can select  the  fx   logo  an  then  you  can  base the value  of this  constant  line based on your measure.  Now  based  on  selection,  your constant  line  (or threshold)  will change.