Forum Discussion
Create a Line Chart with a Target Line
Hi Anonymous,
Nope, current power bi does not support to use legend fields and multiple values field at the same time. (Analysis panel excited triage line, but it is static values. if you want to make it dynamic, you need to add your value field to the visual fields, then you can choose it in the options)
I think you may need to modify your table structure to unpivot these fields to attribute and value, then you can use attribute on legend and value in the Value field to achieve your requirement.Unpivot columns (Power Query)
Regards,Xiaoxin Sheng
Hi Anonymous,
Nope, current power bi does not support to use legend fields and multiple values field at the same time. (Analysis panel excited triage line, but it is static values. if you want to make it dynamic, you need to add your value field to the visual fields, then you can choose it in the options)
I think you may need to modify your table structure to unpivot these fields to attribute and value, then you can use attribute on legend and value in the Value field to achieve your requirement.
Unpivot columns (Power Query)
Regards,
Xiaoxin Sheng