Forum Discussion
PBOBOP
Helper I
Helper ILine Values in the Line and Column Clustered Chart
Hello, I am trying to create a line and column clustered chart to show the average volumes per day per person (Columns) and the average volumes per day between the selected people(Line), by thei...
Hi PBOBOP ,
You can create another measure to put in Line y-axis.
Measure = AVERAGEX('Medicine',[Average Volume/Day])If the above measure doesn't work, try the below. If your visual's name field is from table 'Items', I'd prefer to trust you to use this measure.
Measure = AVERAGEX('Items',[Average Volume/Day])Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi PBOBOP ,
You can create another measure to put in Line y-axis.
Measure = AVERAGEX('Medicine',[Average Volume/Day])
If the above measure doesn't work, try the below. If your visual's name field is from table 'Items', I'd prefer to trust you to use this measure.
Measure = AVERAGEX('Items',[Average Volume/Day])
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.