Forum Discussion
db042190
Impactful Individual
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 dat...
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.
db042190Impactful Individual
Impactful Individuali got rid of the dashed lines. and no the lines arent going back on themselves.