Forum Discussion
Impactful Individualline chart not behaving as expected
hi im standing up the multi series line chart shown below that basically is meant to show % changes in/for different foreign currency exchange rates against the dollar. my changes (currency,eom date over last year, change %) come in one record per currency x month. i've already tried showing the change as % vs not in the transform. i know for a fact that currency INR went down 4% in march 2026. yet when i filter that out, not only dont i see a spike in march but the y axis stays as a low of 0 to a high of 2. and no matter what i filter currency wise, i always see a horiontal line of one "glommed" color at y=1. i did visit the magnifying glass according to AI for allowing separate ungrouped series and thought i followe the instructions. i'll post in a reply what that all looks like. im going t look up how to squeeze more months on the x axis visually. i know they are all there but i want to see them too.
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.
3 Replies
rohit1991Super User
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.
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.
- db042190
i got rid of the dashed lines. and no the lines arent going back on themselves.