Forum Discussion
Dynamic constant line
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
What I want, when I choose for another year in the filter, my budget (constant line) changes automatically. Is there a possibility to achieve this?
The "constant line" you mentioned is the constant line option in Analytics pane, right? If it is, what does "based on a hardcoded budget" mean? Could you clarify more details about the cuurent settings and your expected result?
Regards,
Jimmy Tao
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?
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
