Moving Alert Line for Line Graph

[hmil]

I have a line graph showing what quantity is available of a certain capacity.  On the same page I have a location slicer.  I would like to put an alert line at 75% of the total capacity so the user knows when to order more hardware.  This line must react to the slicer.  How do I do this?

[v-frfei-msft]

Hi @hmil,

I make a test using my sample table and get the following chart. If the chart doesn’t return your expected result, please share sample data of your table here and post desired result.

1. Enter the data accordingly and create the measure as below.

per = 
var a = CALCULATE(SUM(Table1[quantity]),ALLEXCEPT(Table1,Table1[location]))
var b =CALCULATE(SUM(Table1[certain]),ALLEXCEPT(Table1,Table1[location]))
return
a/b

2. Create the line visual as below and add a Constant Line in the Analytics pane.

For more detail, please check the pbix as attached.

https://www.dropbox.com/s/0k1xvc96tcztx4u/Moving%20Alert%20Line%20for%20Line%20Graph.pbix?dl=0

Regards,
Frank

[v-frfei-msft]

Hi @hmil,

Does that make sense? If so , could you please mark this answer as a solution?

Regards,
Frank