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

 
 
marcoselias's avatar
marcoselias
Advocate V
6 years ago

Is the measure that you are going to use as a constant line evaluating to the 5.2bn that you are expecting? you can verify this with a card visual and dragging the measure to the Fields well. If it is evaluating correctly, did you drag the measure as a value of the visual (step 3 above) before going to the analytics tab to add a new Min Line, Max Line, etc. (step 4)? Also, double-check the formatting of the line in case its color blends with the background of your visual (step 5). Good luck! Don't forget to flag a a solution as it may help others.