Forum Discussion
Create a Line Chart with a Target Line
- Anonymous5 years ago
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
Anonymous , not very clear. You can have diff measure and plot that on line?
- Anonymous5 years agoNot applicable
These values are column values. Id like the Earn Hours Sum column to appear as line. Cant figure out how to put two columns in for values. Is that possible.