Help with index line in visualization

[Mikkellex]

Hello, 

I need help with an index line. How can i set a fixed line to my y-axis as part of my index axis. The line should be fixed at index 100 to indicate whether we are on target or not (see illustration below).  

Secondly, how can I set index as percentage instead of the current number? (so 1,0 should be 100% instead). 

Thank you in advance

BR, Mikkel 

[v-haibl-msft · Accepted solution]

@Mikkellex

You can create a measure with following formula to set a fixed line.

fixed_Measure = 60

If we want the secondary axis to be percentage, we can only add column/measure which do the percentage calculation into Line values. But cannot add line which represents the sales number as below.

 

Best Regards,
Herbert

[Mikkellex]

Thank you for your help, it worked. 

BR,