Forum Discussion
Impactful Individualline chart not behaving as expected
Hii db042190
The chart is using Count of Ratechange, so each currency/month returns 1, which explains the horizontal line at Y = 1. In the Y-axis field dropdown, change the aggregation to Average or Max, or use:
Rate Change % = MAX ( 'YourTable'[Ratechange] )Format the measure as Percentage and place it on the Y-axis. For more months, use the actual Date field instead of Date Hierarchy and set X-axis > Type = Continuous.
Super UserHii db042190
The chart is using Count of Ratechange, so each currency/month returns 1, which explains the horizontal line at Y = 1. In the Y-axis field dropdown, change the aggregation to Average or Max, or use:
Rate Change % = MAX ( 'YourTable'[Ratechange] )Format the measure as Percentage and place it on the Y-axis. For more months, use the actual Date field instead of Date Hierarchy and set X-axis > Type = Continuous.
db042190thx. hate to pile on but its much better. however im seeing dashed lines in addition to solid ones. and wonder if thats some sort of additional calc/intelligence that i wasnt expecting and dont want. how do i get rid of those? also when the noise clears im wondering why some of the lines go back on themselves. didnt expect that. look at the solid green line as an example.