Forum Discussion
Help with index line in visualization
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
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
2 Replies
v-haibl-msftMicrosoft Employee
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,
HerbertThank you for your help, it worked.
BR,