Forum Discussion
Solved
Control line in a dynamic chart
Hello everyone, i have a graph in which i want to insert a conrol line. in the dashboard there is a slicer to choose a range of dates and because of this i need that the control line will be dynamic...
noamshn Review the attached screenshot based on Date Range selected Control Line would be updated.
Days Difference = DATEDIFF(MIN('Table'[Date]),MAX('Table'[Date]),DAY)
Control Line = [Days Difference]*3Hope it works.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
did you use line and clustered column chart? because in the card visual i see the value correct but in the chart the value is 0.
noamshn I'm using Clustered Column chart and use control line as a constant line. You can add constant line by using Analytics Pane. Please review the attached screenshot.
Hope it works.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!