Forum Discussion
Line chart show multiple lines based on selected values
Hi Anonymous97
With 'values' in the Legend field, Power BI will attempt to create a separate line for each unique value in the 'values' column. If 'values' is the same for both 'id' = 1 and 'id' = 2, Power BI will naturally try to combine these because it sees them as not distinct. If you want separate lines for each 'id' , you can create a new column that concatenates 'id' and 'values' to make them unique and then put the new column in legend.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous ,
Thank you for the reply.
I have already tried this by concatenating the id and value and I was able to acheive the requirement, but when we hover over the legend it is showing both id and values concatenated and the user only wants to see the values.
Hi Anonymous97
You only need to make sure that the values of the legends of id=1 and id=2 are not the same, not necessarily the splicing of id and value.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.