Forum Discussion
Solved
Multiple values in line chart with legend
Hi, I run into the problem of not being able to put multiple values in a line chart and also have a legend. It seems to be it's either a legend or multple values. I think it is really logic to wa...
- This is a lot of info to put on one single graph. I think you could do it by creating a custom column to use in legend - the column would need to be in a format such as: CategoryA - Norm, CategoryA - Score, CategoryB - Norm, CategoryB - Score, etc
Then you put the measure in values and the new column as your legend. Your measure would need updating with a switch to check if the type is Norm or Score and then use the correct calculation.
AllisonKennedy your post gave me inspiration to do some magic on the data and I think it worked!
Still need to do some datachecks, but for now it looks good! Thanks