Forum Discussion

noamshn's avatar
noamshn
Frequent Visitor
2 years ago
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...
Need Help
  • fahadqadir3's avatar
    fahadqadir3
    2 years ago

    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]*3

    Hope it works.

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!! 

fahadqadir3's avatar
fahadqadir3
Solution Supplier
2 years ago

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]*3

Hope it works.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!! 

noamshn's avatar
noamshn
Frequent Visitor
2 years ago

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.

 

  • fahadqadir3's avatar
    fahadqadir3
    Solution Supplier
    2 years ago

    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!!