Forum Discussion
Resolver Iline chart: individual fixed value line for each Legend.
Without developer options you cant have 2 interchangable lines (one moving data and one fixed value). the way i resolved it is in the back in SQL or you can do it in querry editor as well. I have created 2 entries per record, one is real data and second is fixed value. I also created seperate filter with names of the records in order to: when i select that name on the line chart it will filter for me two lines at the same time. the result in visual context will is same as in the picture above. It's not very sophisticated way but it gives me what i want.
you can do it in power bi as well. i used custom visual of kpi. you can have to columns in value and after i modified it as i needded i changed back to what is standart visual from power bi and two lines remained on it.
Resolver II have fixed values what max value should be. and i want them to appear for each line i select.
for example that blue line can take take values from 0 to 4.7 and i have the max value in seperate column. when i select one particular line i want to see the ongoing value and the max value as a horisontal line. like it is on the picture, but on picture line is from analitics MAX Value.
Resolver IWithout developer options you cant have 2 interchangable lines (one moving data and one fixed value). the way i resolved it is in the back in SQL or you can do it in querry editor as well. I have created 2 entries per record, one is real data and second is fixed value. I also created seperate filter with names of the records in order to: when i select that name on the line chart it will filter for me two lines at the same time. the result in visual context will is same as in the picture above. It's not very sophisticated way but it gives me what i want.
- giorgilomidze
you can do it in power bi as well. i used custom visual of kpi. you can have to columns in value and after i modified it as i needded i changed back to what is standart visual from power bi and two lines remained on it.