How do I put the threshold reference line on the X-axis?

%3CLINGO-SUB%20id%3D%22lingo-sub-1549251%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20put%20the%20threshold%20reference%20line%20on%20the%20X-axis%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1549251%22%20slang%3D%22en-US%22%3EAnyone%3F%20I've%20been%20blocked%20by%20this%20all%20day.%20No%20answers%20anywhere.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1549451%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20put%20the%20threshold%20reference%20line%20on%20the%20X-axis%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1549451%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F741656%22%20target%3D%22_blank%22%3E%40Jhilene%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EThis%20shows%20up%20best%20with%20a%20linechart%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-cpp%22%3E%3CCODE%3EPerf%0A%7C%20where%20TimeGenerated%20%26gt%3B%20ago(1d)%20%0A%7C%20where%20CounterName%20%3D%3D%20%22%25%20Processor%20Time%22%20%0A%7C%20summarize%20avg(CounterValue)%2C%20percentiles(CounterValue%2C%2050%2C%2095)%20%20by%20bin(TimeGenerated%2C%201h)%0A%7C%20extend%20Threshold%20%3D%2020%0A%7C%20render%20timechart%20%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CDIV%20id%3D%22tinyMceEditorClive%20Watson_0%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1550933%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20put%20the%20threshold%20reference%20line%20on%20the%20X-axis%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1550933%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239477%22%20target%3D%22_blank%22%3E%40Clive%20Watson%3C%2FA%3E%26nbsp%3BI%20see%20it%20does%2C%20but%20I%20do%20not%20understand%20how%20alerts%20graph%20is%20able%20to%20do%20it%20with%20a%20bar%20graph%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fplatform%2Falerts-log%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fplatform%2Falerts-log%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1548979%22%20slang%3D%22en-US%22%3EHow%20do%20I%20put%20the%20threshold%20reference%20line%20on%20the%20X-axis%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1548979%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20place%20a%20threshold%20line%20on%20the%20x-axis%20using%20this%20query%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3EPerf%0A%7C%20where%20TimeGenerated%20%26gt%3B%20ago(1d)%20%0A%7C%20where%20CounterName%20%3D%3D%20%22%25%20Processor%20Time%22%20%0A%7C%20summarize%20avg(CounterValue)%2C%20percentiles(CounterValue%2C%2050%2C%2095)%20%20by%20bin(TimeGenerated%2C%201h)%0A%7C%20extend%20Threshold%20%3D%2020%0A%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHowever%2C%20it%20is%20not%20giving%20me%20the%20option%20to%20have%201%20threshold%20line%20on%20the%20x%20axis.%20It's%20called%20a%20%22reference%20line%22%2C%20according%20to%20this%20tutorial%3A%26nbsp%3B-ERR%3AREF-NOT-FOUND-%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Flog-query%2Fcharts%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Flog-query%2Fcharts%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EI've%20attached%20an%20image.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1548979%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EQuery%20Language%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

I am trying to place a threshold line on the x-axis using this query

 

Perf
| where TimeGenerated > ago(1d) 
| where CounterName == "% Processor Time" 
| summarize avg(CounterValue), percentiles(CounterValue, 50, 95)  by bin(TimeGenerated, 1h)
| extend Threshold = 20

 

 

However, it is not giving me the option to have 1 threshold line on the x axis. It's called a "reference line", according to this tutorial: https://docs.microsoft.com/en-us/azure/azure-monitor/log-query/charts

I've attached an image.

3 Replies
Anyone? I've been blocked by this all day. No answers anywhere.

@Jhilene 


This shows up best with a linechart 

 

Perf
| where TimeGenerated > ago(1d) 
| where CounterName == "% Processor Time" 
| summarize avg(CounterValue), percentiles(CounterValue, 50, 95)  by bin(TimeGenerated, 1h)
| extend Threshold = 20
| render timechart 
 

 

@Clive Watson I see it does, but I do not understand how alerts graph is able to do it with a bar graph https://docs.microsoft.com/en-us/azure/azure-monitor/platform/alerts-log