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

miltenburger's avatar
miltenburger
Helper V
7 years ago

Thanks v-yuta-msft for your reply.

The constant line in the analytics pane that's right.

How i implemented the constant line right now:

 

 

 

 

 

 

 

 

 

 

 

My value in column "Waarde" is hardcoded. But actually I want this value to change dynamicaly when I change the year filter on my report. Is there a possibility for this?

 

v-yuta-msft's avatar
v-yuta-msft
Community Support
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